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();
        }