<asp:TemplateColumn>
<ItemTemplate>
<asp:CheckBox ID="CheckBox1" runat="server" AutoPostBack="True" />
</ItemTemplate>
</asp:TemplateColumn>
SqlConnection sqlcon = new SqlConnection(DbHelperSQL.connectionString);
SqlCommand sqlcom;
for (int i = 0; i <= DataGrid1.Items.Count - 1; i++)
{
CheckBox cbox = (CheckBox)DataGrid1.Items[i].FindControl("CheckBox1");
if (cbox.Checked == true)
{
string sqlstr = "delete from kyxmry where K_ID='" + DataGrid1.DataKeys[i] + "'";
sqlcom = new SqlCommand(sqlstr, sqlcon);
sqlcon.Open();
sqlcom.ExecuteNonQuery();
sqlcon.Close();
}
}
DataGridDataBind();
<ItemTemplate>
<asp:CheckBox ID="CheckBox1" runat="server" AutoPostBack="True" />
</ItemTemplate>
</asp:TemplateColumn>
SqlConnection sqlcon = new SqlConnection(DbHelperSQL.connectionString);
SqlCommand sqlcom;
for (int i = 0; i <= DataGrid1.Items.Count - 1; i++)
{
CheckBox cbox = (CheckBox)DataGrid1.Items[i].FindControl("CheckBox1");
if (cbox.Checked == true)
{
string sqlstr = "delete from kyxmry where K_ID='" + DataGrid1.DataKeys[i] + "'";
sqlcom = new SqlCommand(sqlstr, sqlcon);
sqlcon.Open();
sqlcom.ExecuteNonQuery();
sqlcon.Close();
}
}
DataGridDataBind();
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货