Retrieve date from sql and store it in a textbox

Question

Hi I retrive date from database. It is in the format of yyyy-mm-dd. Now i want to put this date into masked textbox. Masked text box date format is dd-mm-yyyy. I am not getting correct date format in my masked textbox. Darma

Sudhakar Chaudhary · Answer

if (con.State == ConnectionState.Closed) { con.Open(); } SqlCommand cmd = new SqlCommand(select convert(varchar(10)date103)as date from table1 con); maskedTextBox1.Text = (string)cmd.ExecuteScalar(); SqlCommand cmd = new SqlCommand(insert into table1 values(''''''' + Convert.ToDateTime(maskedTextBox1.Text).ToLongDateString() + ') con); if (con.State == ConnectionState.Closed) { con.Open(); } cmd.ExecuteNonQuery();

Abhijit barua · Answer

select convert(chardate_field103) as date_field from table_name