Question

C#怎样将dataGridView中数据存入数据库啊？

for (int i = 0; i < this.dataGridView1.RowCount; i++)
{
this.dataGridView1.Rows[i].Cells[6].Value = "未定位";
string id0 = this.dataGridView1.Rows[i].Cells[0].Value.ToString();
string addr0 = this.dataGridView1.Rows[i].Cells[1].Value.ToString();
string gas0 = this.dataGridView1.Rows[i].Cells[2].Value.ToString();
string chr0 = this.dataGridView1.Rows[i].Cells[3].Value.ToString();
string uin0 = this.dataGridView1.Rows[i].Cells[4].Value.ToString();
string sta0 = this.dataGridView1.Rows[i].Cells[5].Value.ToString();
string pos0 = this.dataGridView1.Rows[i].Cells[6].Value.ToString();
string tim0 = this.dataGridView1.Rows[i].Cells[7].Value.ToString();
string str0 = string.Format("insert into TABLE2 values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')", id0, addr0, gas0, chr0, uin0, sta0, pos0, tim0);
SqlCommand cmd0 = new SqlCommand(str0);
cmd0.Connection = con;
SqlDataReader reader0 = cmd0.ExecuteReader();;
}
我这样写为什么只能存入9行再多了就不存了，请各位指导啊

Answer 1

估计是 dataGridView 这个分页了吧 他只是会这一页的数据 循环dataGridView的数据源吧 这样没什么问题了

Answer 2

看下你this.dataGridView1.RowCount的值是多少，是不是9

Answer 3

用sqldataadapter会快点吧。。。

Answer 4

你就录九行吧

Answer 5

估计是Rowcount只有9，另外不建议在循环里面直接执行sql插入