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.);