const string conn = @"user=sa;pwd=AbzQ75691;database=erp;server=192.168.2.20";
foreach (DataGridViewRow gvr in dataGridView1.Rows)
{
var con = new SqlConnection(conn);
var adapter = new SqlDataAdapter
{
DeleteCommand = new SqlCommand(string.Format("delete from [escale_std] where identifier= '{0}'",gvr.Cells[0].Value.ToString().Trim()), con)
};
con.Open();
adapter.DeleteCommand.ExecuteNonQuery(); //先删除后导入数据
con.Close();
}
foreach (DataGridViewRow gvr in dataGridView1.Rows)
{
var con = new SqlConnection(conn);
var adapter = new SqlDataAdapter
{
DeleteCommand = new SqlCommand(string.Format("delete from [escale_std] where identifier= '{0}'",gvr.Cells[0].Value.ToString().Trim()), con)
};
con.Open();
adapter.DeleteCommand.ExecuteNonQuery(); //先删除后导入数据
con.Close();
}