在DataGrid中经弹出窗口确认后执行操作（删除）。（附在DataGrid

2022-07-15 80酷酷网 80kuku.com

datagrid|弹出窗口|执行前台代码：
<asp:Label id="Message" runat="server"></asp:Label>

 <asp:datagrid id="BigClassList" Width="100%" CellPadding="3" Runat="server" DataKeyField="BigClassID" OnUpdateCommand="MyDataGrid_Update" OnCancelCommand="MyDataGrid_Cancel" OnEditCommand="MyDataGrid_Edit" OnDeleteCommand="MyDataGrid_Del" OnSortCommand="MyDataGrid_Sort" OnItemCreated="MyDataGrid_ItemCreated" AutoGenerateColumns="False" AllowSorting="True">
 <HeaderStyle Font-Bold="True" BackColor="Gainsboro"></HeaderStyle>
 <Columns>
 <asp:BoundColumn DataField="BigClassID" ReadOnly="True" HeaderText="大类编号" SortExpression="BigClassID"></asp:BoundColumn>
 <asp:BoundColumn DataField="BigClassName" HeaderText="大类名称" SortExpression="BigClassName"></asp:BoundColumn>
 <asp:BoundColumn DataField="BigClassSortID" HeaderText="排序编号" SortExpression="BigClassSortID"></asp:BoundColumn>
 <asp:EditCommandColumn ButtonType="LinkButton" UpdateText="更新" CancelText="返回" EditText="编辑"></asp:EditCommandColumn>
 <asp:TemplateColumn>
 <ItemTemplate>
 <asp:LinkButton id="cmdDel" runat="server" Text="删除" CommandName="Delete"></asp:LinkButton>
 </ItemTemplate>
 </asp:TemplateColumn>
 </Columns>
 </asp:datagrid>
 <table height="23" cellSpacing="0" cellPadding="3" width="100%" boder="0">
 <tr>
 <td bgColor="#efefef">添加新大类</td>
 </tr>
 <TR>
 <TD>类别名称：
 <asp:TextBox id="bclassName" runat="server"></asp:TextBox>
 <asp:Label id="AddMessage" runat="server"></asp:Label></TD>
 </TR>
 <tr>
 <td>排序编号：
 <asp:TextBox id="bclassID" runat="server"></asp:TextBox></td>
 </tr>
 <TR>
 <TD>
 <asp:Button id="btnAddbclass" runat="server" Text="添加大类(A)"></asp:Button></TD>
 </TR>
 </table>

后台代码：
private void Page_Load(object sender, System.EventArgs e)
 {
 // 在此处放置用户代码以初始化页面
 myConn=new OdbcConnection(ConnStr);

 if (!IsPostBack)
 BindGrid("BigClassID");
 }

 public void BindGrid(string sortfield)
 {
 // 绑定数据
 // OdbcDataAdapter myDataAdapter= new OdbcDataAdapter("select * from BigClass order by BigClassID desc", myConn);

 // DataSet ds = new DataSet();
 // myDataAdapter.Fill(ds, "BigClass");

 // BigClassList.DataSource=ds.Tables["BigClass"].DefaultView;
 // BigClassList.DataBind();

 OdbcDataAdapter myDataAdapter = new OdbcDataAdapter("select * from BigClass", myConn);

 DataSet ds = new DataSet();
 myDataAdapter.Fill(ds, "BigClass");

 DataView Source = ds.Tables["BigClass"].DefaultView;
 Source.Sort = sortfield;

 BigClassList.DataSource=Source;
 BigClassList.DataBind();

 }

 public void MyDataGrid_Edit(Object sender, DataGridCommandEventArgs e)
 {
 // 将当前行置为编辑状态
 BigClassList.EditItemIndex = (int)e.Item.ItemIndex;
 BindGrid("BigClassID");
 }

 public void MyDataGrid_Cancel(Object sender, DataGridCommandEventArgs e)
 {
 // 将当前行置为非编辑状态
 BigClassList.EditItemIndex = -1;
 BindGrid("BigClassID");
 }

 public void MyDataGrid_Update(Object sender, DataGridCommandEventArgs e)
 {
 // 更新当前行
 string BigClassID=e.Item.Cells[0].Text;
 string BigClassName=Regex.Replace(((TextBox)e.Item.Cells[1].Controls[0]).Text,"'","''");
 string BigClassSortID=((TextBox)e.Item.Cells[2].Controls[0]).Text;

 String updateCmd = "UPDATE BigClass SET BigClassName ='" + BigClassName + "',"
 + "BigClassSortID=" + BigClassSortID
 + " where BigClassID =" + BigClassID;

 myComm = new OdbcCommand(updateCmd, myConn);

 myComm.Connection.Open();

 try
 {
 myComm.ExecuteNonQuery();
 // Response.Write("已更新记录
");
 Message.Text = "已更新记录
";
 BigClassList.EditItemIndex = -1;
 }
 catch (OdbcException exc)
 {
 Message.Text="错误：" + exc.Message.ToString() + "";
 }

 myComm.Connection.Close();
 BindGrid("BigClassID");
 }

 public void MyDataGrid_ItemCreated(Object sender, DataGridItemEventArgs e)
 {
 // 删除大类
 LinkButton l=new LinkButton();
 switch(e.Item.ItemType)
 {
 case(ListItemType.Item):

 l=(System.Web.UI.WebControls.LinkButton)e.Item.FindControl("cmdDel");
 l.Attributes.Add("OnClick","return confirm('确定要删除该大类吗？');");
 break;

 case(ListItemType.AlternatingItem):

 l=(System.Web.UI.WebControls.LinkButton)e.Item.FindControl("cmdDel");
 l.Attributes.Add("OnClick","return confirm('确定要删除该大类吗？');");
 break;
 }
 }


 protected void MyDataGrid_Del(Object sender, DataGridCommandEventArgs e)
 {
 myConn=new OdbcConnection(ConnStr);
 myConn.Open();

 string BigClassID=e.Item.Cells[0].Text;;
 string deleteCmd = "DELETE from BigClass where BigClassID =" + BigClassID;
 myComm=new OdbcCommand(deleteCmd,myConn);
 myComm.ExecuteNonQuery();

 BindGrid("BigClassID");
 }

 protected void MyDataGrid_Sort(Object sender, DataGridSortCommandEventArgs e)
 {
 BindGrid(e.SortExpression);
 }

 private void btnAddbclass_Click(object sender, System.EventArgs e)
 {
 string bClassName=Regex.Replace(bclassName.Text,"'","''");
 string bClassID=bclassID.Text;

 if(bClassName!="" & bClassID!="")
 {

 myConn=new OdbcConnection(ConnStr);
 myConn.Open();

 string InsertInto="INSERT INTO BigClass (BigClassName,BigClassSortID) values ("
 + "'" + bClassName + "',"
 + bClassID + ")";
 // Response.Write(InsertInto);



 myComm=new OdbcCommand(InsertInto,myConn);
 myComm.ExecuteNonQuery();

 bclassName.Text="";
 bclassID.Text="";

 AddMessage.Text="已经添加新的文章大类！";

 BindGrid("BigClassID");

 }
 else
 {
 AddMessage.Text="请填写完整！";
 }

 }