Storing and retrieving dates from MS Access using C#

Hello,

I am facing difficulty in storing date in MS Access using C# code. I have tried to save the DateTime object into the database. The column in the database was also of DateTime datatype. but I could not save the date. It gave me syntax error.

Then I tried to save the date as a String. But this time the date got saved in the database as some decimal. Plz help me in this regard. How to save the date in MS Access.

Thanking you,

Quote:

---

Originally Posted by quincydur1998

Hello,

I am facing difficulty in storing date in MS Access using C# code. I have tried to save the DateTime object into the database. The column in the database was also of DateTime datatype. but I could not save the date. It gave me syntax error.

Then I tried to save the date as a String. But this time the date got saved in the database as some decimal. Plz help me in this regard. How to save the date in MS Access.

Thanking you,

---

Please, show us how you tried to do it.

What error do you have, any screenshots?

Quote:

---

Originally Posted by Baileybob

What error do you have, any screenshots?

---

No screenshots please, just include the code snippet and the error.