how to save date and time in db at the time of form submissi

Hi Atul,

Please use this link,

https://www.codeproject.com/Questions/720666/How-can-I-save-time-to-sql-Time-DataType

0

Hey first get the date time value like this, var now=DateTime.Now(); and store this value in database using insert query in specific column. Thanks.

0

Rajanikant Hawaldar6y ago

You should add one column in database table, provide name to it and set data type as datetime, in insert query you can pass current datetime. https://stackoverflow.com/questions/1032495/insert-datetime-value-in-sql-database-with-c-sharp/1032519 https://stackoverflow.com/questions/28461295/insert-datetime-now-from-asp-net-into-sql-server

+1