Loading

Error - Conversion failed when converting date and/or time

Jagjit Saini

Hi

SqlCommand cmd = new SqlCommand("INSERT INTO [Period] (Date1,Date2) VALUES('" + @Date11 + "','" + @Date12 + "')", con);
cmd.Parameters.AddWithValue("@Date11", txt_Date11.Text.Trim());
cmd.Parameters.AddWithValue("@Date12", txt_Date12.Text.Trim());
Thanks

1 Reply

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

Imran Munir7y ago
Just make sure with your date format please,
DateTime.Parse(txt_Date11.Text.Trim());