后台代码:
Dim con As New OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0;data source=" & Server.MapPath("db2.mdb"))
Dim cmd As New OleDbCommand
cmd.Connection = con
con.Open()
Dim objItem As DataGridItem
Dim objcheck As HtmlInputCheckBox
For Each objItem In DataGrid1.Items
objcheck = objItem.FindControl("check2")
If objcheck.Checked = True Then
cmd.CommandText = "delete from 表1 where ID=" & DataGrid1.DataKeys(objItem.ItemIndex)
cmd.ExecuteNonQuery()
End If
Next
con.Close()
CheckBox chk=(CheckBox)this.DataGrid1.FindControls("chked")//checked是你模板中的CheckBox控件的ID
foreach(DataGridItem dm in this.DataGrid1.Items)
{
if(dm.checked)
{
cmd.ExcuteQuerstring("delete from table where BianHao='")+dm.cells[1].Text;
}