Loading

error when inserting sql database from datagridview

error when inserting sql database from datagridview

Vedant

11y1kVisual Basic .NET

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.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sourabh Somani11y ago
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.");

0