C# .NET - Passing Date value to SQL

Hi Frndz,

Functionality:  Pass Date value dd/mm/yyyy to Sql server

To achieve this task,

First set Culture in UK format

CultureInfo MyUsersCulture = Thread.CurrentThread.CurrentCulture;

Thread.CurrentThread.CurrentCulture = new CultureInfo("en-GB");

After then Parse to Date in dd/mm/yyyy format ( your string Date must be in dd/mm/yyyy format)

   DateTime dtTemp = DateTime.ParseExact(dateString, "dd/MM/yyyy", null);

Now Store dtTemp Value to DB table

Full Logic     :

        CultureInfo MyUsersCulture = Thread.CurrentThread.CurrentCulture;

        Thread.CurrentThread.CurrentCulture = new CultureInfo("en-GB");

        string dateString = "30/12/2012";

        // in order not to have to specify a FormatProvider

        DateTime dtTemp = DateTime.ParseExact(dateString, "dd/MM/yyyy", null);

Hope this helpful!

Thanks

To get current date in c# use DateTime.Now.ToString()............ there is also some different methods under Now.... use what is appropriate for u .

first u must have to set date value in UK culture.... then

if u r using a procedure it is easier..... say proc. name  saveCurrentDate

String s=DateTime.Now.ToString(); 

String queryString="saveCurrentDate '"+s+"'"; //// or String queryString="insert int myTable(mydate) values ('"+s+"')";

hope it will hellped u