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

ASKER CERTIFIED SOLUTION

Éric Moreau

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

IT Genesis

ASKER

thanks ^_^

it_saige

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

-saige-