How do I add a date using C# & SQL to an MS Access database with column type 'Date/Type'?

Question

I have tried using a DateTimePicker with format dd/MM/yyyy to insert a date into a Date/Time column in my MS Access database using the insert SQL statement.

Here is what I have done:

connection.Open();

OleDbCommand command = new OleDbCommand();
command.Connection = connection; // Connecting the command to the connection.
command.CommandText = "insert into [TestEntry] (TestTableID, StudentID, DateOfTest, [DeadLine]) values(" + int.Parse(txtTestName.Text) + ", " + int.Parse(studentID) + ", #" + this.dateTimeStartD.Text + "# , #" + this.dateTimeEndD.Text + "#)";

command.ExecuteNonQuery();
connection.Close();

I keep getting the error

Input string was not in correct format

The Date/Time columns in my Access table are formatted as 'Short date' eg. 12/11/2015.

Any help will be appreciated.

I have been using this way to insert values into my Access tables through out my program and have had no issues. I think I am getting the error because I am not passing the date data from the dateTimePicker correctly. — user5379214
– user5379214, Commented Apr 16, 2016 at 18:43
it would be better for you to follow this instructions: stackoverflow.com/questions/1402173/… — Ivan Yuriev
– Ivan Yuriev, Commented Apr 16, 2016 at 18:49

Telan Niranga · Accepted Answer · 2016-04-16 18:53:38Z

1

I do not think its coming from database level. This exception is coming when you try to case value which in different format. Please check you first argument for the insert statement.

int.Parse(txtTestName.Text)

You are trying to insert integer value to "TestTableID" field by converting text box value to integer. Please check your text box input is number or characters. It should be only numbers.

answered Apr 16, 2016 at 18:53

Telan Niranga

4574 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How do I add a date using C# & SQL to an MS Access database with column type 'Date/Type'?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related