Question

ASP.NET 获取Gridview中checkbox选中的值.每次插入数据库都是插入2条数据.

ASP.NET 获取Gridview中checkbox选中的值.每次插入数据库都是插入2条数据.我GridView中总共就2条数据.不管我选中哪一条数据,都是插入2条. string strconnc = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["sqlconnectionstring"].ConnectionString;//定义数据库连接字符串 SqlConnection sqlcon = new SqlConnection(strconnc); for (int i = 0; i <= GridView1.Rows.Count-1; i++) { string da = this.GridView1.Rows[i].Cells[1].Text; foreach (GridViewRow item in GridView1.Rows) { if (((CheckBox)item.FindControl("CheckBox1")).Checked) { SqlCommand sqlcom = new SqlCommand("insert into CheckData (ct1) values('" + da + "')", sqlcon); sqlcon.Open(); sqlcom.ExecuteNonQuery(); sqlcon.Close(); } } }

Answer 1

for (int i = 0; i <= GridView1.Rows.Count-1; i++)循环两次