telerik:RadGrid 学习笔记 （增删查改）

ASP页面代码

<fieldset style="width: 97%">
      <telerik:RadAjaxPanel runat="server" ID="p1" Width="100%">
            <telerik:RadGrid ID="RadGrid1" runat="server" GridLines="None"
                AllowPaging="True" PageSize="1" AllowSorting="True" Width="100%" AutoGenerateColumns="False"
                EnableAJAX="True" ShowStatusBar="True" CellSpacing="0" Skin="Web20" 
                OnUpdateCommand="RadGrid1_UpdateCommand" OnInsertCommand="RadGrid1_InsertCommand"
                OnDeleteCommand="RadGrid1_DeleteCommand" OnNeedDataSource="RadGrid1_NeedDataSource">
                <PagerStyle Mode="NextPrevAndNumeric"></PagerStyle>
                <MasterTableView CommandItemDisplay="Top" GridLines="None" DataKeyNames="序号" EditMode="InPlace" NoMasterRecordsText="没有您要查询的数据">
                <PagerStyle FirstPageToolTip="第一页" LastPageToolTip="最后一页"  NextPageToolTip="下一页" PrevPageToolTip="上一页" PageSizeLabelText="每页显示:" ShowPagerText="False" />
                <CommandItemSettings ExportToPdfText="导出PDF" AddNewRecordText="添加新项" RefreshText="刷新">
                    </CommandItemSettings>
                    <Columns>
                        <telerik:GridTemplateColumn HeaderText="机柜标识" UniqueName="机柜标识" SortExpression="机柜标识">
                            <ItemTemplate>
                                <asp:Label runat="server" ID="lbljgbs" Text='<%# Eval("机柜标识") %>'></asp:Label></ItemTemplate>
                            <EditItemTemplate>
                                <asp:TextBox ID="txtjgbs" runat="server" Text='<%# Eval("机柜标识") %>' Width="70%"></asp:TextBox></EditItemTemplate>
                        </telerik:GridTemplateColumn>
                        <telerik:GridTemplateColumn HeaderText="规格" UniqueName="规格" SortExpression="规格">
                            <ItemTemplate>
                                <asp:Label runat="server" ID="lbljgg" Text='<%# Eval("规格") %>'></asp:Label></ItemTemplate>
                            <EditItemTemplate>
                                <asp:TextBox ID="txtgg" runat="server" Text='<%# Eval("规格") %>' Width="70%"></asp:TextBox></EditItemTemplate>
                        </telerik:GridTemplateColumn>
                        <telerik:GridTemplateColumn HeaderText="备注" UniqueName="备注">
                            <ItemTemplate>
                                <asp:Label runat="server" ID="lbljbzz" Text='<%# Eval("备注") %>'></asp:Label></ItemTemplate>
                            <EditItemTemplate>
                                <asp:TextBox ID="txtbz" runat="server" Text='<%# Eval("备注") %>' TextMode="MultiLine" Width="70%"></asp:TextBox></EditItemTemplate>
                        </telerik:GridTemplateColumn>
                        
                       <telerik:GridEditCommandColumn ButtonType="ImageButton" UniqueName="EditCommandColumn" HeaderText="修改"
                            EditText="修改">
                            <HeaderStyle Width="60px" HorizontalAlign="Center"></HeaderStyle>
                            <ItemStyle HorizontalAlign="Center" />
                        </telerik:GridEditCommandColumn>

                        <telerik:GridClientDeleteColumn ConfirmTextFields="机柜标识" ConfirmTextFormatString="您确定删除 {0} ? "
                            ButtonType="ImageButton" HeaderText="删除" Text="删除">
                            <HeaderStyle Width="40px" HorizontalAlign="Center"></HeaderStyle>
                            <ItemStyle HorizontalAlign="Center" />
                        </telerik:GridClientDeleteColumn>

                    </Columns>
                    
                    
                </MasterTableView>
                <ClientSettings AllowColumnsReorder="True" ReorderColumnsOnClient="True" EnableRowHoverStyle="true">
                    <Selecting AllowRowSelect="True" />
                    <ClientEvents OnRowDblClick="RowDblClick" />
                    <Resizing EnableRealTimeResize="True" ResizeGridOnColumnResize="True" AllowColumnResize="True">
                    </Resizing>
                </ClientSettings>
            </telerik:RadGrid>
        </telerik:RadAjaxPanel>
    </fieldset>

.CS代码

protected void RadGrid1_NeedDataSource(object source, GridNeedDataSourceEventArgs e)
        {
            try
            {
                IList<机柜表> jgb = BLL.机柜类.根据区域ID查询所有机柜信息(73);
                RadGrid1.DataSource = jgb;
                //RadGrid1.DataSource = ddal.GetAll();
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }

        }
        protected void RadGrid1_DeleteCommand(object source, GridCommandEventArgs e)
        {
            //Get the GridDataItem of the RadGrid    
            
            //Get the primary key value using the DataKeyValue.    
            //int xuhao = Convert.ToInt32(item.OwnerTableView.DataKeyValues[item.ItemIndex]["序号"]);
            try
            {
                GridDataItem dataItem = (GridDataItem)e.Item;
                int xuhao = Convert.ToInt32(dataItem.GetDataKeyValue("序号").ToString());
                BLL.机柜类.根据序号删除机柜(xuhao);
            }
            catch (Exception ex)
            {
                RadGrid1.Controls.Add(new LiteralControl("Unable to delete . Reason: " + ex.Message));
                e.Canceled = true;
            }

        }
        protected void RadGrid1_UpdateCommand(object source, GridCommandEventArgs e)
        {
            //Get the GridEditableItem of the RadGrid    
            //GridEditableItem editedItem = e.Item as GridEditableItem;
            //Get the primary key value using the DataKeyValue.    
           // int xuhao = Convert.ToInt32(editedItem.OwnerTableView.DataKeyValues[editedItem.ItemIndex]["序号"]);
            //Access the textbox from the edit form template and store the values​​ in string variables.    

            GridDataItem dataItem = (GridDataItem)e.Item;

           
            try
            {
                int xuhao = Convert.ToInt32(dataItem.GetDataKeyValue("序号").ToString());
                string jgbs = (dataItem.FindControl("txtjgbs") as TextBox).Text;
                string gg = (dataItem.FindControl("txtgg") as TextBox).Text;
                string bz = (dataItem.FindControl("txtbz") as TextBox).Text;

                机柜表 jgb = new 机柜表();
                jgb.序号 = xuhao;
                jgb.备注 = bz;
                jgb.规格 = gg;
                jgb.机柜标识 = jgbs;
                jgb.所在区域序号 = 73;
                BLL.机柜类.修改机柜信息(jgb);
            }
            catch (Exception ex)
            {
                RadGrid1.Controls.Add(new LiteralControl("Unable to update . Reason: " + ex.Message));
                e.Canceled = true;
            }

        }
        protected void RadGrid1_InsertCommand(object source, GridCommandEventArgs e)
        {
            //Get the GridEditFormInsertItem of the RadGrid    
            //GridEditFormInsertItem dataItem = (GridEditFormInsertItem)e.Item;

            //string EmployeeID  = (insertedItem["EmployeeID"].Controls[0] as TextBox).Text;  


            try
            {
                GridDataItem dataItem = (GridDataItem)e.Item;
                string jgbs = (dataItem.FindControl("txtjgbs") as TextBox).Text;
                string gg = (dataItem.FindControl("txtgg") as TextBox).Text;
                string bz = (dataItem.FindControl("txtbz") as TextBox).Text;
                机柜表 jgb = new 机柜表();
                jgb.备注 = bz;
                jgb.规格 = gg;
                jgb.机柜标识 = jgbs;
                jgb.所在区域序号 = 73;

                BLL.机柜类.新增机柜(jgb);


            }
            catch (Exception ex)
            {
                RadGrid1.Controls.Add(new LiteralControl("Unable to insert . Reason: " + ex.Message));
                e.Canceled = true;
            }

        }

效果图：