I am saving two data, One is date and other one is time in SQL server 2005 using asp.net ( VB.net).
I am saving this using following command:
cmd.commandtext = "insert into TABLE1 values ('" + Now.toshortdatestring + "', '" + Now.toshorttimestring + "')"
now while i am using this code in Windows Xp its working properly but in Windows VISTA it is showing some "Data Conversion Error from string to datetime".
If i remove the single quotes [ ' ] from the command it is showing error in the value of date and time.
View Complete Post