date conversion

Try, when writing:

string date = DateTime.ParseExact(textBox1.Text, "dd/MM/yyyy", null).ToString("MM/dd/yyyy");

and when reading (assuming read from database to a DateTime variable dt):

textBox1.Text = dt.ToString("dd/MM/yyyy");

This link might help u out...
http://www.sql-server-helper.com/tips/date-formats.aspx

You can use it in the Select Query

anil john14y ago

I am entering date in text box as 01/10/2012 in my table all date time will be saved as 10/01/2012 10:54:30 AM ,so that i want to convert my date to this format while saving and retain the date from table to text box as 01/10/2012 while reading the date

Shivanand Arur14y ago

Can you elaborate your question... Where do you exactly wanna do this conversion?