Insert DateTime in a field

Question

I have the next code: SqlCommand command = new SqlCommand(); command.CommandText = INSERT INTO Custumers (Num Name AddressCity 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?

Carlos Sanchez · Answer

I tried use dtpBirthdayDate.Value.TimeOfDay but an exception was thrown: Wrong Line: Command.Parametrs.Add(@BirthdatDate dtpBirthdayDate.Value.TimeOfDay) Exception: Index (zero based) must be greater than or equal to zero and less than the size of the argument list. do you know where is the error? thanx

miker · Answer

dtpBirthdayDate.Value.TimeOfDay will gve you what you want. However if only a time is specified when setting a datetime or smalldatetime value the date in the database defaults to January 1 1900.

Carlos Sanchez · Answer

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 AddressCity 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 the 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

Carlos Sanchez · Answer

I did it!!!! Thank you jamesdivine Carlos

james · Answer

hmm... you might try something like this System.Data.SqlTypes.SqlDateTime t = new System.Data.SqlTypes.SqlDateTime(DateTime.Now); t.Value;

Carlos Sanchez · Answer

I tried it allready but the Date is converted to string and when I want store the date in the table the next error is ocured: Syntax error converting datetime from character string. Any Idea else? Thank you.

james · Answer

use the ToShortDateString() method like this dtpBirthdatDate.Value.Date.ToShortDateString()