CODEWITHSUNDEEP
c#visual-studioms-access
Jonald Samilo
Jonald Samilo

Reputation: 325

Saving Date and Time

I don't know why the date and time is not saving on my Access Database. I follow some tutorial but it seems I'm having some problems on my code. 

DateTime getdate = DateTime.Now;
String time = getdate.ToString("F");

and when I add

OleDbCommand cmdInsert = new OleDbCommand(@"insert into TblInventory (ItemCode,ProductName,Quantity,DateTime)
values ('" + txtItem.Text + "','" + txtProduct.Text + "','" + txtQuantity.Text + "','" + time +"')");
cmdInsert.Connection = con;
cmdInsert.ExecuteNonQuery();

Im stock. please help. thanks guys

The error says that there are problem on the insert into statement

Upvotes: 1

Views: 421

Answers (1)

Mairaj Ahmad
Mairaj Ahmad

Reputation: 14604

Name of your column is DateTime which is a keyword. You need to change name of column. Also use Parameterized query don't concatenate strings in query.

List of reserved words.

Upvotes: 1

Related Questions