storing date in sqlserver

[srivalli]

i am using back end as sql server

from vb.net i want to store a date in one column say(fromdate)
what i did is
i placed datetimepicker,and i am retrieving the date in a textbox

now in sqlserver
i declared that date column as smalldatetime datatype

now when i am trying to store date from vb.net,
then error is displayed
now what to do
any suggestions
welcome
thks

 

[ayozzhero]

Can you post:
1. the Query String used to 'save' the date into the database
2. the Error Message

 

[srivalli]

i got the answer

the problem is in sqlserver,i am declaring a variable in smalldatetime.
and if i to save this date column in dd/mm/yyyy,then error is coming
if i am using MM/dd/yyyy
then the date is being stored in the back end.
thank u

Can you post:
1. the Query String used to 'save' the date into the database
2. the Error Message