datagrid添加删除修改记录

.aspx

< asp:datagrid id = " dgData "  runat = " server "  Width = " 100% "  CssClass = " GridBackColor "  AllowSorting = " True "
                                        AutoGenerateColumns = " False "  BorderColor = " #999999 "  BackColor = " #F0F0E8 "  PageSize = " 10 "  ShowFooter = " True " >
                                         < ItemStyle Wrap = " False " ></ ItemStyle >
                                         < HeaderStyle Wrap = " False "  CssClass = " GridHeadBackColor " ></ HeaderStyle >
                                         < Columns >
                                             < asp:TemplateColumn HeaderText = " 类别编号 "  Visible = " true " >
                                                 < HeaderStyle Wrap = " False "  HorizontalAlign = " Center " ></ HeaderStyle >
                                                 < ItemTemplate >
                                                     < asp:Label id = " lbllbbh "  runat = " server "  Text = ' <%# DataBinder.Eval(Container, "DataItem.dclbid") %> ' >
                                                     </ asp:Label >
                                                 </ ItemTemplate >
                                             </ asp:TemplateColumn >
                                             < asp:TemplateColumn HeaderText = " 类别名称 "  Visible = " true " >
                                                 < HeaderStyle Wrap = " False "  HorizontalAlign = " Center " ></ HeaderStyle >
                                                 < ItemTemplate >
                                                     < asp:Label id = " lbllbmc "  runat = " server "  Text = ' <%# DataBinder.Eval(Container, "DataItem.dclbmc") %> ' >
                                                     </ asp:Label >
                                                 </ ItemTemplate >
                                                 < EditItemTemplate >
                                                     < asp:TextBox id = " txtlbmc1 "  runat = " server "  Text = ' <%# DataBinder.Eval(Container, "DataItem.dclbmc") %> ' >
                                                     </ asp:TextBox >
                                                 </ EditItemTemplate >
                                                 < FooterTemplate >
                                                     < asp:TextBox Width = " 98% "  id = " txtlbmc "  runat = " server "  CssClass = " edline "  Text = '' ></ asp:TextBox >
                                                 </ FooterTemplate >
                                             </ asp:TemplateColumn >
                                             < asp:TemplateColumn >
                                                 < HeaderStyle HorizontalAlign = " Center " ></ HeaderStyle >
                                                 < ItemStyle Wrap = " False "  HorizontalAlign = " Center "  Width = " 30px " ></ ItemStyle >
                                                 < ItemTemplate >
                                                     < asp:LinkButton id = " Linkbutton3 "  runat = " server "  Text = " <img src='../images/edit.gif' border=0 alt=修改当前记录> "
                                                        CausesValidation = " false "  CommandName = " Edit " ></ asp:LinkButton >
                                                 </ ItemTemplate >
                                                 < FooterStyle HorizontalAlign = " Center " ></ FooterStyle >
                                                 < FooterTemplate >
                                                     < asp:LinkButton id = " Linkbutton2 "  runat = " server "  Text = " 新增 "  CausesValidation = " false "  CommandName = " Update " ></ asp:LinkButton >
                                                 </ FooterTemplate >
                                                 < EditItemTemplate >
                                                     < asp:LinkButton id = " Linkbutton4 "  runat = " server "  Text = " <img src='../images/save.gif' border=0 alt='保存修改'> "
                                                        CausesValidation = " false "  CommandName = " Update " ></ asp:LinkButton >
                                                     < asp:LinkButton id = " Linkbutton5 "  runat = " server "  Text = " <img src='../images/delete.gif' border=0 alt=取消修改> "
                                                        CausesValidation = " false "  CommandName = " Cancel " ></ asp:LinkButton >
                                                 </ EditItemTemplate >
                                             </ asp:TemplateColumn >
                                             < asp:TemplateColumn >
                                                 < HeaderStyle HorizontalAlign = " Center " ></ HeaderStyle >
                                                 < ItemStyle Wrap = " False "  HorizontalAlign = " Center "  Width = " 30px " ></ ItemStyle >
                                                 < ItemTemplate >
                                                     < asp:LinkButton id = " LinkButton1 "  runat = " server "  Text = " <img src='../images/delete.gif' border=0 alt=删除当前记录> "
                                                        CausesValidation = " false "  CommandName = " Delete " ></ asp:LinkButton >
                                                 </ ItemTemplate >
                                                 < EditItemTemplate >
                                                 </ EditItemTemplate >
                                             </ asp:TemplateColumn >
                                             < asp:BoundColumn Visible = " False " ></ asp:BoundColumn >
                                         </ Columns >
                                         < PagerStyle Mode = " NumericPages " ></ PagerStyle >
                                     </ asp:datagrid >

.aspx.cs

private   void  dgData_CancelCommand( object  source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
         {
            dgData.EditItemIndex=-1;
            BindData();
        }

         private   void  dgData_DeleteCommand( object  source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
         {
            Label lbllbbh=(Label)e.Item.FindControl("lbllbbh");
            string sql="delete dclb where dclbid='"+lbllbbh.Text+"'";
            SqlData.ExecuteNonQuery(DbConfig.GetSetting(),CommandType.Text,sql);
            BindData();
        }

         private   void  dgData_EditCommand( object  source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
         {
            dgData.EditItemIndex=e.Item.ItemIndex; 
            BindData();
        }

         private   void  dgData_ItemCreated( object  sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
         {
            if (e.Item.ItemIndex>=0)
            {
                e.Item.Attributes.Add("onMouseOver", "javascript:this.bgColor='#C6D7E7';");
                e.Item.Attributes.Add("onMouseOut", "javascript:this.bgColor='#F0F0E8';");
            } 


            System.Web.UI.WebControls.LinkButton TempImage;
            TempImage =(System.Web.UI.WebControls.LinkButton) e.Item.FindControl("LinkButton1");
            if (TempImage != null)
                TempImage.Attributes.Add("onclick", "return confirm('确定要删除该记录吗?')");
        }
private   void  dgData_UpdateCommand( object  source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
         {
            TextBox lbmc;
            if (dgData.EditItemIndex>=0)  //修改
            {
                if (e.Item.ItemIndex<0 || e.Item.ItemIndex >=dgData.Items.Count )
                    return;
                lbmc =(TextBox)e.Item.FindControl("txtlbmc1");
            }
            else//新增
            {
                lbmc =(TextBox)e.Item.FindControl("txtlbmc");
            } 
            if(lbmc.Text=="")
            {
                PageCtrl.ShowMessage(this,"类别名称不可为空!");
                return ;
            }
            try
            {
                if (dgData.EditItemIndex>=0)  //修改 
                {
                    Label lbllbbh=(Label)e.Item.FindControl("lbllbbh");
                    string sql="update dclb set dclbmc='"+lbmc.Text+"' where dclbid="+lbllbbh.Text+"";
                    //                    Response.Write(sql);
                    SqlData.ExecuteNonQuery(DbConfig.GetSetting(),CommandType.Text,sql);
                }
                else
                {
                    string sql="insert into dclb(dclbmc) values('"+lbmc.Text+"')";
                    
                    SqlData.ExecuteNonQuery(DbConfig.GetSetting(),CommandType.Text,sql); 
                }
            }
            catch(Exception ex)
            {
                PageCtrl.ShowMessage(this,ex.Message);
                return ;
            } 
            dgData.EditItemIndex=-1; 
            BindData();
        }

转载于:https://www.cnblogs.com/yangtu86/archive/2006/04/20/379959.html