string s = "";
for (int i = 0; i < dataGridViewX1.Rows.Count; i++)
{
s = s + "insert into DateFact values(" + dataGridViewX1.Rows[i].Cells[0].Value + ",'" + dataGridViewX1.Rows[i].Cells[1].Value + "',N'" + dataGridViewX1.Rows[i].Cells[2].Value + "',N'" + dataGridViewX1.Rows[i].Cells[3].Value + "')" + ";";
}
s = s.Remove(s.Length - 1, 1);
SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector y|\bank\BAnbar.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");
con.Open();
SqlCommand cmd = new SqlCommand(s, con);
cmd.ExecuteNonQuery();
con.Close();
ارور میده