asp.net - How do I store 'date' in SQL Server 2005 using C# query -

an error while storing date in db (sql server 2005) using c# using,

datetime mydate = datetime.now;  insert mytablename (appdate) values('"+mydate.toshortdatestring()+"'); 

bt showing error when run query

also tried,

mydate.toshortdatestring().tostring("dd-mmm-yyyy hh:mm:ss") in c# , still showing error in editor only.

how store 'date' in sql server 2005 using c# query

use parameterized sql, , set value parameter:

string sql = "insert tablename (appdate) values (@appdate)"; using (var connection = new sqlconnection(...)) {     connection.open();     using (var command = new sqlcommand(sql, connection))     {         command.parameters.add("@appdate", sqldbtype.datetime).value             = datetime.now;         int rowsinserted = command.executenonquery();         // todo: validation of result (you'd expect 1)     } } 

you should always use parameterized sql when have data include in request database. avoids sql injection attacks , data conversion issues, keeping code cleaner.

you should consider whether want local date/time or utc date/time. example, might want use datetime.utcnow instead.