بله کم کردم الان دیگه هیچی insert نمی کنه اینم کدم:
SqlConnection connect = new SqlConnection();
connect.ConnectionString = Total.Properties.Settings.Default.Connection.ToStr ing();
for (int i = dataGridView1.Rows.Count - 1; i <= 0; i--)
{
try
{
connect.Open();
string s = "Insert into EmissionDoc (Id,NumReceipt,AccCode,Center1)values(@Id,@NumRece ipt,@AccCode,@Center1)";
SqlCommand Cmd = new SqlCommand(s, connect);
Cmd.Parameters.AddWithValue("Id", Convert.ToInt32(dataGridView1.Rows[i].Cells[0].Value.ToString()));
Cmd.Parameters.AddWithValue("NumReceipt", Convert.ToInt32(textBox1.Text));
Cmd.Parameters.AddWithValue("AccCode", dataGridView1.Rows[i].Cells[1].Value.ToString());
Cmd.Parameters.AddWithValue("Center1", dataGridView1.Rows[i].Cells[2].Value.ToString());
Cmd.ExecuteNonQuery();
}
catch (Exception exp)
{
MessageBox.Show(exp.Message.ToString());
}
finally
{
connect.Close();
}
}