Insert DateTime in a field

Carlos Sanchez

I have the next code: SqlCommand command = new SqlCommand(); command.CommandText = "INSERT INTO Custumers (Num, Name, Address,City, State, BirthdayDate) VALUES (" + txtNum.Text + "," + txtName.Text + "," + txtAddress.Text + "," + txtCity.Text + "," + txtState.Text + "," + dtpBirthdatDate.Value.Date + ")"; command.ExecuteNonQuery(); dtpBirthdayDate is a DateTimePicker Component. When the command is executed the next error is ocurred: Line 1: Incorrect syntax near '12'. Any TextBox have the "12" string n' the dtpBirthdayDate (DateTimePicker) have {7/13/2004}. But when I start the application step by step, I can see that the dtpBirthdayDate value is 07/13/2004 12:00:00 a.m. may be this is the problem, but what can I do? can sombody help me?

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Carlos Sanchez22y ago
Another question. I managed to inert a DateTime value in the table. I have used the next code: SqlCommand command = new SqlCommand(); command.CommandText = "INSERT INTO Custumers (Num, Name, Address,City, State, BirthdayDate) VALUES (" + txtNum.Text + "," + txtName.Text + "," + txtAddress.Text + "," + txtCity.Text + "," + txtState.Text + ", @BirthdayDate )"; Command.Parametrs.Add(@BirthdatDate ,dtpBirthdayDate.Value.Date) command.ExecuteNonQuery(); Now, also I want to insert a DateTime value, but just the time. I tried do the same and it works, but when I check the DataBase content, tha value that I inserted was something like: 28/07/2004 12:00:00 I want to insert just the time How to do it? Thanking in advance
0
Carlos Sanchez22y ago
Thank you bunny, it really help me.
0
Giovanni Bejarasco22y ago
Try using dtpBirthdatDate.Value.ToString("mm/dd/yyy") instead of dtpBirthdatDate.Value.Date. For more format, consult the DateTime.ToString() section of the Documentation. Hope this help. :)
0
Carlos Sanchez22y ago
the runtime values appears like this: INSERT INTO Custumers (Num, Name, Address,City, State, BirthdayDate) VALUES (1,John,123 Street,Paris,France,07/13/2004 12:00:00 a.m.) I have changed the code, I wrote the values within quotes and now the runtime value of the command is like this: INSERT INTO Custumers (Num, Name, Address,City, State, BirthdayDate) VALUES (1,'John','123 Street','Paris','France','07/13/2004 12:00:00 a.m.') But now has ocured another error: "Syntax error converting datetime from character string. This is because I declared BirthdayDate as DateTime. if I don't write the quotes the error is: Line 1: Incorrect syntax near '12'. Any Idea? Thank you
0
Adam Erstelle22y ago
Can you paste the runtime value of the commandtext variable? I have a feeling the date is not formatted properly. Also, it appears that the string values are not contained within quotes. eg: INSERT INTO Custumers (Num, Name, Address,City, State, BirthdayDate) VALUES (1,John,123 Street,Paris,France,7/13/2004) Should actually read: INSERT INTO Custumers (Num, Name, Address,City, State, BirthdayDate) VALUES (1,'John','123 Street','Paris','France','7/13/2004') I am not sure how the date has to be formatted for the server you are using.
0