delete FROM news_property where news_id in (获得以选中的ID)
int id=Convert.ToInt32(MyDataItem.Cells[0].Text);这个错了`` 因为你第一列识chekbox 你最好设置datagrid的datakeyfield为id int id=(int)DataGrid1.DataKey[MyDataItem.itemindex]
private void grdTerm_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { int intJls = 0; for(int i=0;i<grdTerm.Items.Count;i++) { CheckBox chk = (CheckBox)grdTerm.Items[i].FindControl("chk1"); if (chk.Checked) { OleDbConnection connDel = new OleDbConnection(strCnn); connDel.Open(); string sql_Del = "DELETE FROM ThisTerm " + " WHERE dm = '" + grdTerm.Items[i].Cells[5].Text+"'"; OleDbCommand OleDbCommandDel = new OleDbCommand(sql_Del,connDel); OleDbCommandDel.ExecuteNonQuery(); connDel.Close(); intJls++; } } if (grdTerm.Items.Count==intJls && grdTerm.CurrentPageIndex>0) { grdTerm.CurrentPageIndex -= 1; } grdTerm.EditItemIndex = -1; grdTerm.DataSource = CreateDataSource(); grdTerm.DataBind();
能不能把ASPX文件贴给我看看呀,:)
int id=Convert.ToInt32(MyDataItem.Cells[0].Text);这个错了``因为你第一列识chekbox 你最好设置datagrid的datakeyfield为id int id=(int)DataGrid1.DataKey[MyDataItem.itemindex]另外,你应该把错误给贴出来,这样我们才发现错误 我发现还有你这段代码也不是最有效的 你应该先判断 在做下一步的处理 if (ok) { myCmd.ExecuteNonQuery(); myCmd.Connection.Close(); }你的Connection有没有打开啊
因为你第一列识chekbox 你最好设置datagrid的datakeyfield为id
int id=(int)DataGrid1.DataKey[MyDataItem.itemindex]
{
int intJls = 0;
for(int i=0;i<grdTerm.Items.Count;i++)
{
CheckBox chk = (CheckBox)grdTerm.Items[i].FindControl("chk1");
if (chk.Checked)
{
OleDbConnection connDel = new OleDbConnection(strCnn);
connDel.Open();
string sql_Del = "DELETE FROM ThisTerm " +
" WHERE dm = '" + grdTerm.Items[i].Cells[5].Text+"'";
OleDbCommand OleDbCommandDel = new OleDbCommand(sql_Del,connDel);
OleDbCommandDel.ExecuteNonQuery();
connDel.Close();
intJls++;
}
}
if (grdTerm.Items.Count==intJls && grdTerm.CurrentPageIndex>0)
{
grdTerm.CurrentPageIndex -= 1;
}
grdTerm.EditItemIndex = -1;
grdTerm.DataSource = CreateDataSource();
grdTerm.DataBind();
int id=(int)DataGrid1.DataKey[MyDataItem.itemindex]另外,你应该把错误给贴出来,这样我们才发现错误 我发现还有你这段代码也不是最有效的
你应该先判断 在做下一步的处理
if (ok)
{
myCmd.ExecuteNonQuery();
myCmd.Connection.Close(); }你的Connection有没有打开啊