16,722
社区成员




for (int i = 0; i < dataGridView1.RowCount - 1; i++)
{
d1 = dataGridView1[1, i].Value.ToString();
d2 = dataGridView1[2, i].Value.ToString();
d3 = dataGridView1[3, i].Value.ToString();
//插入数据库操作
string sqlSelect = string.Format("insert into newtable(字段1,字段2,字段3)values('{0}','{1}','{2}')", d1, d2, d3);
SqlCommand scd = new SqlCommand(sql,conn);
conn.Open();
int result = scd.ExecuteNonQuery();
conn.Close();
}
类似这样