Insert date into sql server database

[somtabu]

I have a problem. The problem is..................

In vb.net, there is a form with a Datetimepicker. in the database(sql server) there is a field with a DateTime data type. now I want to send date from the form to database..... Please help me.....

[dip_developer]

I have a problem. The problem is..................

In vb.net, there is a form with a Datetimepicker. in the database(sql server) there is a field with a DateTime data type. now I want to send date from the form to database..... Please help me.....

have you tried anything....have you written any sql insert statement.....give us the code.....inserting date is very simple.......

if you need some idea of how to write sql then serach in net........

[debasisdas]

You need to capture the date from the picker control and pass the same to database using SQL statment . You might have to convert to proper format before inserting.

[Plater]

If your database has a Date/Time column (we'll call it say "EntryDate")
If you are building your SQL statement as a direct string, you can use the single quote ' around a .ToString() on your DateTime object in VB.NET and the database will understand it.

If you are using a stored procedure, you can set the parameter type to be DateTime and then set it's value to be the DateTime object itself.