protected void dg_results_ItemCreated(object sender, GridItemEventArgs e) { if (e.Item is GridDataItem) { HyperLink editLink = (HyperLink)e.Item.FindControl("EditLink"); editLink.Attributes["href"] = "#"; editLink.Attributes["onclick"] = String.Format("return ShowEditForm('{0}','{1}');", e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["FileId"], e.Item.ItemIndex); } }<CommandItemTemplate> <div style="padding: 5px 5px 5px 5px; float: right; display: inline"> <asp:LinkButton ID="RebindButton" runat="server" CommandName="RebindGrid" ToolTip="Refresh"> <asp:Image ID="RebindImage" runat="server" ImageUrl="~/Images/Refresh.gif" ImageAlign="Middle" /> </asp:LinkButton> </div> </CommandItemTemplate> 
<
td class="style6">
<telerik:RadGrid ID="RadGrid2" runat="server" DataSourceID="SalesOrderDetails"
GridLines="None" AllowFilteringByColumn="True" AllowPaging="True"
AllowSorting="True" AutoGenerateEditColumn="True">
<MasterTableView AutoGenerateColumns="False" DataSourceID="SalesOrderDetails">
<CommandItemSettings ExportToPdfText="Export to Pdf" />
<RowIndicatorColumn>
<HeaderStyle Width="20px" />
</RowIndicatorColumn>
<ExpandCollapseColumn>
<HeaderStyle Width="20px" />
</ExpandCollapseColumn>
<Columns>
<telerik:GridBoundColumn DataField="ItemNo" HeaderText="ItemNo"
SortExpression="ItemNo" UniqueName="ItemNo">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="ItemDesc" HeaderText="ItemDesc"
SortExpression="ItemDesc" UniqueName="ItemDesc">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Quantity" DataType="System.Int16"
HeaderText="Quantity" SortExpression="Quantity" UniqueName="Quantity">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="PdtLine" HeaderText="PdtLine"
SortExpression="PdtLine" UniqueName="PdtLine">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="CustPrice" DataType="System.Decimal"
HeaderText="CustPrice" SortExpression="CustPrice" UniqueName="CustPrice">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Currency" HeaderText="Currency"
SortExpression="Currency" UniqueName="Currency">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Clumpcode" HeaderText="Clumpcode"
SortExpression="Clumpcode" UniqueName="Clumpcode">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="SalesOrder" HeaderText="SalesOrder"
SortExpression="SalesOrder" UniqueName="SalesOrder">
</telerik:GridBoundColumn>
</Columns>
</MasterTableView>
<ClientSettings>
<Scrolling AllowScroll="True" UseStaticHeaders="True" />
</ClientSettings>
</telerik:RadGrid>
<asp:SqlDataSource ID="SalesOrderDetails" runat="server"
ConnectionString="<%$ ConnectionStrings:Contract-LookupConnectionString %>"
SelectCommand="SELECT ItemNo, ItemDesc, Quantity, PdtLine, CustPrice, Currency, Clumpcode, SalesOrder FROM SalesOrderDetail WHERE (SalesOrder = @SalesOrder)"
UpdateCommand="UPDATE [SalesOrderDetail] Set [Clumpcode]=? Where [SalesOrder]=?" >
<SelectParameters>
<asp:ControlParameter ControlID="MOOGSO" Name="SalesOrder" PropertyName="Text"
Type="String" />
</SelectParameters>
<UpdateParameters>
<asp:Parameter Name="Clumpcode" Type="String" />
<asp:Parameter Name="SalesOrder" Type="String" />
</UpdateParameters>
</asp:SqlDataSource>
</td>
ASPX:
<telerik:RadGrid ID="gridCustomer" runat="server" OnNeedDataSource="gridCustomer_NeedDataSource" OnUpdateCommand="OrderDetail_UpdateCommand" OnDetailTableDataBind="gridOrder_DetailTableDataBind"> <MasterTableView DataKeyNames="CustomerID" Width="100%" PageSize="20" ClientDataKeyNames="CustomerID" > <DetailTables> <telerik:GridTableView DataKeyNames="OrderID" Name="OrderDetail" EditMode="InPlace" > <Columns> <telerik:GridBoundColumn DataField="OrderName" HeaderText="Order Name" ReadOnly="true"/> <telerik:GridBoundColumn DataField="DateReceived" HeaderText="Date Received" ReadOnly="true" /> <telerik:GridTemplateColumn HeaderText="Amount to Pay" EditFormColumnIndex="1" HeaderStyle-Width="140px" > <ItemTemplate> <asp:Label runat="server" ID="lblAmountToPay" Text='<%# Eval ("AmountToPay", "{0:C}") %>'> </asp:Label> </ItemTemplate> <EditItemTemplate> <telerik:RadNumericTextBox runat="server" ID="tbxUnitPrice" Width="40px" DbValue='<%# Bind("AmountToPay") %>'> </telerik:RadNumericTextBox> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridEditCommandColumn UniqueName="EditOrderPrice" /> </Columns> </telerik:GridTableView> </DetailTables> <Columns> <telerik:GridClientSelectColumn UniqueName="ClientSelectColumn" /> <telerik:GridBoundColumn DataField="CustomerName" HeaderText="Customer Name"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Address" HeaderText="Address"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Phone" HeaderText="Phone"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Email" HeaderText="Email"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Group" HeaderText="Group"> </telerik:GridBoundColumn> </Columns> </MasterTableView> <ClientSettings> <Selecting AllowRowSelect="True" /> <ClientEvents OnRowSelected="GridCustomerRowSelected" /> </ClientSettings> </telerik:RadGrid> CODE BEHIND
protected void gridCustomer_NeedDataSource(object source, GridNeedDataSourceEventArgs e) { gridCustomer.DataSource = ClaimProcess.GetCustomer(); } protected void gridOrder_DetailTableDataBind(object source, GridDetailTableDataBindEventArgs e) { switch (e.DetailTableView.Name) { case "OrderDetail": { GridDataItem dataItem = e.DetailTableView.ParentItem; e.DetailTableView.DataSource = ClaimProcess.GetOrder(dataItem.GetDataKeyValue("CustomerID")); break; } } } protected void OrderDetail_UpdateCommand(object source, GridCommandEventArgs e) { GridEditableItem item = (GridEditableItem)e.Item; int OrderID = Convert.ToInt32(item.GetDataKeyValue("OrderID")); RadNumericTextBox txtAmountPay = (RadNumericTextBox)e.Item.FindControl("tbxUnitPrice"); UpdateOrder(OrderID, Convert.ToDouble(txtAmountPay.Text)); gridCustomer.Rebind(); }