An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll
Additional information: Conversion failed when converting date and/or time from character string.
cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "INSERT INTO [dbo].[faculty] ([fac_id], [Fname], [Lname], [gender], [dob], [email], [country], [city], [hire_date], [salary], [commission], [fac_rank], [crs_id]) VALUES (@fac_id, @Fname, @Lname, @gender, @dob, @email, @country, @city, @hire_date, @salary, @commission, @fac_rank, @crs_id)";
cmd.Parameters.AddWithValue("@fac_id", fac_idTextBox.Text);
cmd.Parameters.AddWithValue("@Fname", fnameTextBox.Text);
cmd.Parameters.AddWithValue("@Lname", lnameTextBox.Text);
cmd.Parameters.AddWithValue("@gender", genderTextBox.Text);
cmd.Parameters.AddWithValue("@dob", DateTime.Parse(dobDateTimePicker.Text));
cmd.Parameters.AddWithValue("@email", emailTextBox.Text);
cmd.Parameters.AddWithValue("@country", countryTextBox.Text);
cmd.Parameters.AddWithValue("@city", cityTextBox.Text);
cmd.Parameters.AddWithValue("@hire_date", DateTime.Parse(hire_dateDateTimePicker.Text));
cmd.Parameters.AddWithValue("@salary", salaryTextBox.Text);
cmd.Parameters.AddWithValue("@commission", commissionTextBox.Text);
cmd.Parameters.AddWithValue("@fac_rank", fac_rankTextBox.Text);
cmd.Parameters.AddWithValue("@crs_id", crs_idTextBox.Text);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
What I have tried:
all the things plzz help i have submit tomorrow