Loading

Take only date from datatimepicker

prasanna shah

Hi,
How to set datetimepicker to only date and insert into database. I want only date to be inserted into database that is selected from datetimepicker.

thanks, waiting for the reply,

thanks
prasanna

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Datta Kharad15y ago
Hi

string dts = dateTimePicker1.Text ;
//Example:- Sore record into oracle database
cmd.CommandText = "insert into empdbimg(eid,ename,hiredate)values(:eid,:ename,:hiredate,)";
cmd.Parameters.Add (":eid",txteid .Text );
cmd.Parameters.Add (":ename",txtename .Text );
cmd.Parameters.Add (":hiredate",dateTimePicker1.Text );
cmd.Connection = con;
cmd.ExecuteNonQuery();
Pravin More15y ago
Hi Prasanna,
try this code..

radDateTimePicker.Culture = new System.Globalization.CultureInfo("en-US")
{
         DateTimeFormat = new System.Globalization.DateTimeFormatInfo
                      {
                            ShortDatePattern = "dd"
                     }
};

Thanks,
Pravin.