error when inserting sql database from datagridview

Question

i have a string value into my datagridview column when i want to insert row into database its got error.like ESKAY K'N'IT or VENKEY'S (I) its give error kindly help insert datagridview value to insert into database.

Sourabh Somani · Answer

If You want to insert Multiple rows then use following Code foreach (DataGridViewRow row in dataGridView1.Rows) { string constring = @"Data Source=.\sqlexpress;Initial Catalog=MyDB;Integrated Security=true"; using (SqlConnection con = new SqlConnection(constring)) { using (SqlCommand cmd = new SqlCommand("INSERT INTO Customers VALUES(@CustomerId, @Name, @Country)", con)) { cmd.Parameters.AddWithValue("@CustomerId", row.Cells["Id"].Value); cmd.Parameters.AddWithValue("@Name", row.Cells["Name"].Value); cmd.Parameters.AddWithValue("@Country", row.Cells["Country"].Value); con.Open(); cmd.ExecuteNonQuery(); con.Close(); } } } MessageBox.Show("Records inserted."); _____________________________________________________ or if you want insert single row then first of all get row DataGridViewRow row in dataGridView1.Rows[IndexNumer]; string constring = @"Data Source=.\sqlexpress;Initial Catalog=MyDB;Integrated Security=true"; using (SqlConnection con = new SqlConnection(constring)) { using (SqlCommand cmd = new SqlCommand("INSERT INTO Customers VALUES(@CustomerId, @Name, @Country)", con)) { cmd.Parameters.AddWithValue("@CustomerId", row.Cells["Id"].Value); cmd.Parameters.AddWithValue("@Name", row.Cells["Name"].Value); cmd.Parameters.AddWithValue("@Country", row.Cells["Country"].Value); con.Open(); cmd.ExecuteNonQuery(); con.Close(); } } MessageBox.Show("Records inserted.");

error when inserting sql database from datagridview

Answers (1)