Take only date from datatimepicker

Question

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

Datta Kharad · Answer

Hi string dts = dateTimePicker1.Text ; //Example:- Sore record into oracle database cmd.CommandText = insert into empdbimg(eidenamehiredate)values(:eid:ename:hiredate); cmd.Parameters.Add (:eidtxteid .Text ); cmd.Parameters.Add (:enametxtename .Text ); cmd.Parameters.Add (:hiredate dateTimePicker1.Text ); cmd.Connection = con; cmd.ExecuteNonQuery();

Pravin More · Answer

Hi Prasanna try this code.. radDateTimePicker.Culture = new System.Globalization.CultureInfo(en-US) { DateTimeFormat = new System.Globalization.DateTimeFormatInfo { ShortDatePattern = dd } }; Thanks Pravin.