Link to home
Start Free TrialLog in
Avatar of IT Genesis
IT Genesis

asked on

Conversion failed when converting date and/or time from character string

this my error and my code

i have a problem with data fill in database

error is
Conversion failed when converting date and/or time from character string

my data type is date
i put data from text box mode date

User generated image
Avatar of Éric Moreau
Éric Moreau
Flag of Canada image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of IT Genesis
IT Genesis


thanks ^_^
Or better yet, rather than trying to concatenate a string into an insert statement, why not parameterize your string and add your parameters using the commands SqlParameter collection; e.g. -
protected void Button1_Click(object sender, EventArgs e)
    DateTime date1 = DateTime.ParseExact(Txt_refd.Text, "yyyy-MM-dd", null);
    DateTime date2 = DateTime.ParseExact(Txt_out.Text, "yyyy-MM-dd", null);

    using (var command = new SqlCommand())
        command.CommandText = "INSERT INTO FZMain (ID, NAME, ChassisNO, CarModel, LastOwner, Payment, Cases, Refference, RefferenceDate, OutDate, FamilyRegister) " +
            "VALUES (@ID, @NAME, @ChassisNO, @CarModel, @LastOwner, @Payment, @Cases, @Refference, @RefferenceDate, @OutDate, @FamilyRegister)";
        command.Connection = con;
        command.Parameters.AddWithValue("@ID", Txt_ID.Text);
        command.Parameters.AddWithValue("@NAME", Txt_name.Text);
        command.Parameters.AddWithValue("@ChassisNO", Txt_chasses.Text);
        command.Parameters.AddWithValue("@CarModel", Txt_model.Text);
        command.Parameters.AddWithValue("@LastOwner", Txt_owner.Text);
        command.Parameters.AddWithValue("@Payment", Txt_payment.Text);
        command.Parameters.AddWithValue("@Cases", Drop_case.SelectedValue.ToString());
        command.Parameters.AddWithValue("@Refference", Txt_ref);
        command.Parameters.AddWithValue("@RefferenceDate", date1);
        command.Parameters.AddWithValue("@OutDate", date2);
        command.Parameters.AddWithValue("@FamilyRegister", Txt_femreg.Text);
        // Carry on from this point

Open in new window