Thks for ur reply, but it didn't solved my prob. Interesting thing is date format dd/MM/yyyy in getting inserted correctly on my PC. but when i deployed at client location its gets entered as dd-MM-yyyy format coloum Type is varchar 50.

I am using Mysql as my database. i insert the date in the format DateTime.Now.ToString("dd/MM/yyyy") but the strange thing is its gets entered in dd-MM-yyyy format. EVen if i manaually entered the date in database in dd/MM/yyyy and retrive the value from database , its get the format as dd-MM-yyyy. where is the prob???