or

<telerik:RadGrid ID="rgQuotation" runat="server" Width="95%" ShowStatusBar="true" Skin="Office2007" Font-Names="Verdana" AutoGenerateHierarchy="true" AutoGenerateColumns="False" AllowSorting="True" AllowMultiRowSelection="False" AllowPaging="false" ShowFooter="True"> <PagerStyle Mode="NumericPages"></PagerStyle> <MasterTableView Width="100%" DataKeyNames="ID" AllowMultiColumnSorting="True" CommandItemDisplay="Top" HierarchyDefaultExpanded="true" HierarchyLoadMode="ServerBind" Name="Quotation" CssClass="DetailTable_Default"> <Columns> <telerik:GridEditCommandColumn ButtonType="ImageButton" UniqueName="EditCommandColumn" ItemStyle-Width="30px" EditImageUrl="~/Portals/0/Images/Edit.gif"> <ItemStyle BackColor="GreenYellow" /> </telerik:GridEditCommandColumn> <telerik:GridBoundColumn SortExpression="ID" HeaderText="ID" HeaderButtonType="TextButton" DataField="ID" UniqueName="ID" ReadOnly="true" Visible="false"> </telerik:GridBoundColumn> <telerik:GridBoundColumn SortExpression="TariffName" HeaderText="Quotation Name" HeaderButtonType="TextButton" DataField="TariffName" UniqueName="TariffName" ReadOnly="true"> <ItemStyle BackColor="GreenYellow" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn SortExpression="RecordType" HeaderText="Rec Type" HeaderButtonType="TextButton" DataField="RecordType" UniqueName="RecordType" ReadOnly="true" Visible="false"> </telerik:GridBoundColumn> <telerik:GridBoundColumn SortExpression="JobID" HeaderText="Job No" HeaderButtonType="TextButton" DataField="JobID" UniqueName="JobID" ReadOnly="true" Visible="false"> </telerik:GridBoundColumn> <telerik:GridTemplateColumn UniqueName="ShowTotal"> <ItemStyle Width="125px" HorizontalAlign="Left" BackColor="Yellow" /> <FooterTemplate> <asp:Label ID="lblTotalCost" runat="server" Text="dffsafssdf" Font-Bold="true" ForeColor="White" Font-Italic="true"> </asp:Label> <asp:Label ID="lblTotalSelling" runat="server" Text="Total Selling" Font-Bold="true" Visible="false"> </asp:Label> </FooterTemplate> </telerik:GridTemplateColumn> </Columns> <EditFormSettings EditFormType="Template" InsertCaption="New Tariff"> <FormTemplate> <div> <asp:Label ID="lblTariffName" runat="server" Text="Quotation Name" CssClass="fieldsetControlStyle"> </asp:Label> <asp:TextBox ID="txtTariffName" runat="server" Text='<%# Eval("TariffName") %>'> </asp:TextBox> <asp:LinkButton ID="lnkbtnUpdate" runat="server" CausesValidation="True" CommandName='<%# IIf( DataBinder.Eval(Container, "OwnerTableView.IsItemInserted"), "PerformInsert", "Update") %>' CssClass="lnkButton" ToolTip="Update"> <asp:Image ID="imgUpdate" runat="server" ImageUrl="~/Portals/0/Images/Update.gif" /> </asp:LinkButton> <asp:LinkButton ID="lnkbtnCancel" runat="server" CausesValidation="False" CommandName="Cancel" CssClass="lnkButton" ToolTip="Cancel"> <asp:Image ID="imgCancel" runat="server" ImageUrl="~/Portals/0/Images/Cancel.gif" /> </asp:LinkButton> </div> </FormTemplate> </EditFormSettings> <DetailTables> <telerik:GridTableView DataKeyNames="ID" HierarchyLoadMode="ServerBind" Width="100%" HierarchyDefaultExpanded="true" CommandItemDisplay="Top" runat="server" Name="Groups" CssClass="DetailTable_Default"> <Columns> <telerik:GridEditCommandColumn ButtonType="ImageButton" UniqueName="EditCommandColumn" ItemStyle-Width="40px" EditImageUrl="~/Portals/0/Images/Edit.gif"> <ItemStyle BackColor="Yellow" /> </telerik:GridEditCommandColumn> <telerik:GridBoundColumn SortExpression="GroupID" HeaderText="GroupID" HeaderButtonType="TextButton" DataField="GroupID" UniqueName="GroupID" ReadOnly="true" Visible="false"> </telerik:GridBoundColumn> <telerik:GridBoundColumn SortExpression="GroupName" HeaderText="Group Name" HeaderButtonType="TextButton" DataField="GroupName" UniqueName="GroupName"> <ItemStyle Font-Bold="true" BackColor="Yellow" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn SortExpression="TariffID" HeaderText="TariffID" HeaderButtonType="TextButton" DataField="TariffID" UniqueName="TariffID" ReadOnly="true" Visible="false"> <ItemStyle Width="0%" /> </telerik:GridBoundColumn> <telerik:GridTemplateColumn UniqueName="ShowTotal"> <ItemStyle Width="125px" HorizontalAlign="Left" BackColor="Yellow" /> <FooterTemplate> <asp:Label ID="lblTotalCost" runat="server" Text="" Font-Bold="true" ForeColor="White" Visible="true" Font-Italic="true"> </asp:Label> <asp:Label ID="lblTotalSelling" runat="server" Text="Total Selling" Font-Bold="true" Visible="false"> </asp:Label> </FooterTemplate> </telerik:GridTemplateColumn> </Columns> <EditFormSettings EditFormType="Template" InsertCaption="New Group"> <FormTemplate> <div> <asp:Label ID="lblGroupName" runat="server" Text="Group Name" CssClass="fieldsetControlStyle"> </asp:Label> <asp:TextBox ID="txtGroupName" runat="server" Text='<%# Eval("groupname") %>'> </asp:TextBox> <br /> <asp:LinkButton ID="lnkbtnUpdate" runat="server" CausesValidation="True" CommandName='<%# IIf( DataBinder.Eval(Container, "OwnerTableView.IsItemInserted"), "PerformInsert", "Update") %>' CssClass="lnkButton"> <asp:Image ID="imgUpdate" runat="server" ImageUrl="~/Portals/0/Images/Update.gif" /> </asp:LinkButton> <asp:LinkButton ID="lnkbtnCancel" runat="server" CausesValidation="False" CommandName="Cancel" CssClass="lnkButton" ToolTip="Cancel"> <asp:Image ID="imgCancel" runat="server" ImageUrl="~/Portals/0/Images/Cancel.gif" /> </asp:LinkButton> </div> </FormTemplate> </EditFormSettings> <CommandItemSettings AddNewRecordText="Add New Group" AddNewRecordImageUrl="~/Portals/0/Images/AddRecord.gif" ShowRefreshButton="false" /> <DetailTables> <telerik:GridTableView DataKeyNames="ID" Width="100%" Name="Items" CommandItemDisplay="Top" AlternatingItemStyle-BackColor="SkyBlue" CssClass="DetailTable_Default!" EditMode="InPlace" runat="server" HierarchyLoadMode="ServerBind"> <Columns> <telerik:GridEditCommandColumn ButtonType="ImageButton" UniqueName="EditCommandColumn" UpdateImageUrl="~/Portals/0/Images/Update.gif" ItemStyle-Width="40px" EditImageUrl="~/Portals/0/Images/Edit.gif" CancelImageUrl="~/Portals/0/Images/Cancel.gif"> </telerik:GridEditCommandColumn> <telerik:GridBoundColumn SortExpression="ID" HeaderText="ID" HeaderButtonType="TextButton" DataField="ID" UniqueName="ID" ReadOnly="true" Visible="false"> </telerik:GridBoundColumn> <telerik:GridBoundColumn SortExpression="ItemOrder" HeaderText="ItemOrder" HeaderButtonType="TextButton" DataField="ItemOrder" UniqueName="ItemOrder" ReadOnly="true" Visible="false"> </telerik:GridBoundColumn> <telerik:GridTemplateColumn HeaderText="Item Name"> <ItemTemplate> <asp:Label ID="lblItemName" runat="server" Text='<%# Eval("ItemName") %>'></asp:Label> </ItemTemplate> <EditItemTemplate> <asp:TextBox ID="txtItemName" runat="server" Text='<%# Eval("ItemName") %>' MaxLength="100"> </asp:TextBox> <asp:RequiredFieldValidator ID="rfvtxtItemName" runat="server" ErrorMessage="!" Display="Dynamic" ControlToValidate="txtItemName"> </asp:RequiredFieldValidator> </EditItemTemplate> <ItemStyle Width="30%" /> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn HeaderText="Rate" UniqueName="Rate"> <ItemTemplate> <asp:Label ID="lblUnits" runat="server" Text='<%# Eval("Units") %>'></asp:Label> </ItemTemplate> <EditItemTemplate> <telerik:RadNumericTextBox ID="rntbRate" ShowSpinButtons="true" IncrementSettings-InterceptArrowKeys="true" IncrementSettings-InterceptMouseWheel="true" runat="server" Type="Number" Width="80px" DbValue='<%# Eval("Units") %>' NumberFormat-DecimalDigits="2" MinValue="1" IncrementSettings-Step="1" CssClass="fieldsetControlWidth fieldsetLine" /> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn HeaderText="Quantity" UniqueName="Quantity"> <ItemTemplate> <asp:Label ID="lblQuantity" runat="server" Text='<%# Eval("Quantity") %>'></asp:Label> </ItemTemplate> <EditItemTemplate> <telerik:RadNumericTextBox ID="rntbQuantity" ShowSpinButtons="true" IncrementSettings-InterceptArrowKeys="true" IncrementSettings-InterceptMouseWheel="true" runat="server" Type="Number" Width="80px" DbValue='<%# Eval("Quantity") %>' NumberFormat-DecimalDigits="0" MinValue="0" IncrementSettings-Step="1" CssClass="fieldsetControlWidth fieldsetLine"> <ClientEvents OnBlur="Blur" OnFocus="Focus" /> </telerik:RadNumericTextBox> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn HeaderText="C.P" UniqueName="CostPrice"> <ItemTemplate> <asp:Label ID="lblCostPrice" runat="server" Text='<%# Format(DataBinder.Eval(Container.DataItem,"CostPrice"),"###,##0.00") %>'> </asp:Label> </ItemTemplate> <EditItemTemplate> <telerik:RadNumericTextBox ID="rntbCostPrice" ShowSpinButtons="true" IncrementSettings-InterceptArrowKeys="true" IncrementSettings-InterceptMouseWheel="true" runat="server" Type="Number" Width="80px" DbValue='<%# Eval("CostPrice") %>' NumberFormat-DecimalDigits="2" MinValue="0" IncrementSettings-Step="1" CssClass="fieldsetControlWidth fieldsetLine" /> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn HeaderText="S.P" Visible="false"> <ItemTemplate> <asp:Label ID="lblSellingPrice" runat="server" Text='<%# Format(DataBinder.Eval(Container.DataItem,"SellingPrice"),"###,##0.00") %>'> </asp:Label> </ItemTemplate> <EditItemTemplate> <telerik:RadNumericTextBox ID="rntbSellingPrice" ShowSpinButtons="true" IncrementSettings-InterceptArrowKeys="true" IncrementSettings-InterceptMouseWheel="true" runat="server" Type="Number" Width="80px" DbValue='<%# Eval("SellingPrice") %>' NumberFormat-DecimalDigits="2" MinValue="0" IncrementSettings-Step="1" CssClass="fieldsetControlWidth fieldsetLine" /> </EditItemTemplate> </telerik:GridTemplateColumn> <%-- <telerik:GridCalculatedColumn HeaderText="C.P Total" DataType="System.Double" UniqueName="TotalCostPrice" FooterStyle-Font-Bold="true" FooterStyle-ForeColor="White" DataFields="CostPrice,Units,Quantity" Expression="{0}/{1}*{2}" Aggregate="Sum" DataFormatString="{0:###,##0.00}" FooterAggregateFormatString="{0:£###,##0.00}" /> <telerik:GridCalculatedColumn HeaderText="S.P Total " UniqueName="TotalSellingPrice" FooterStyle-ForeColor="White" FooterStyle-Font-Bold="true" Visible="false" DataFields="SellingPrice,Units,Quantity" Expression="{0}/{1}*{2}" DataType="System.Double" FooterAggregateFormatString="{0:£###,##0.00}" FooterText="S.P Total : " Aggregate="Sum" DataFormatString="{0:###,##0.00}" />--%> </Columns> <CommandItemSettings AddNewRecordText="Add New Item" AddNewRecordImageUrl="~/Portals/0/Images/AddRecord.gif" ShowRefreshButton="false" /> </telerik:GridTableView> </DetailTables> </telerik:GridTableView> </DetailTables> <CommandItemSettings AddNewRecordText="Add new Quotation" AddNewRecordImageUrl="~/Portals/0/Images/AddRecord.gif" ShowRefreshButton="false" ShowExportToPdfButton="true" /> </MasterTableView> <ClientSettings AllowKeyboardNavigation="true" EnableRowHoverStyle="true"> <ClientEvents OnRowContextMenu="RowContextMenu" OnRowDblClick="RowDblClick" /> <Selecting AllowRowSelect="true" /> <KeyboardNavigationSettings EnableKeyboardShortcuts="true" AllowSubmitOnEnter="true" AllowActiveRowCycle="true" CollapseDetailTableKey="LeftArrow" ExpandDetailTableKey="RightArrow" /> </ClientSettings> </telerik:RadGrid>Protected Sub rgQuotation_ItemCommand(ByVal source As Object, ByVal e As Telerik.Web.UI.GridCommandEventArgs) Handles rgQuotation.ItemCommand If e.CommandName = "PerformInsert" Then Insert(e) rgQuotation.Rebind() ElseIf e.CommandName = "Update" Then Update(e) rgQuotation.Rebind() End If End Sub Protected Sub rgQuotation_DetailTableDataBind(ByVal source As Object, ByVal e As GridDetailTableDataBindEventArgs) Handles rgQuotation.DetailTableDataBind Dim sql As String Dim sb As New StringBuilder Dim dt As DataTable Select Case e.DetailTableView.Name Case "Groups" Dim nTariffId As String = e.DetailTableView.ParentItem.GetDataKeyValue("ID").ToString() sb.Append("select * from ff_Group where TariffID = " & nTariffId & " and IsDeleted = 0 order by grouporder") sql = sb.ToString dt = DNNDB.Query(sql) e.DetailTableView.DataSource = dt Case "Items" Dim nGroupId As String = e.DetailTableView.ParentItem.GetDataKeyValue("ID").ToString() sb.Append("select * from FF_Item where FF_Item.GroupID = " & nGroupId & " and IsDeleted = 0 order By ItemOrder asc") sql = sb.ToString dt = DNNDB.Query(sql) e.DetailTableView.DataSource = dt End Select End SubProtected Sub rgQuotation_NeedDataSource(ByVal source As Object, ByVal e As Telerik.Web.UI.GridNeedDataSourceEventArgs) Handles rgQuotation.NeedDataSource BindQuotation() End Sub
Protected Sub BindQuotation()
Dim sb As New StringBuilder
sb.Append("select * from ff_tariff where JobID = " & pnJobID & " and Isdeleted = 0 and RecordType = '" & FF_GLOBALS.RECORD_TYPE_QUOTATION & "'")
Dim sql As String = sb.ToString
Dim dt As DataTable = DNNDB.Query(sql)
rgQuotation.DataSource = dt
End Sub
<telerik:RadGrid ID="grdBlock" runat="server" GridLines="None" AllowFilteringByColumn="False" AllowPaging="False" AllowSorting="False" AutoGenerateColumns="true" PageSize="25" OnNeedDataSource="grdBlock_NeedDataSource" Skin="Office2007" CellSpacing="1" Width="900px" EnableLinqExpressions="false" > <GroupingSettings CaseSensitive="false" /> <ExportSettings HideStructureColumns="true" IgnorePaging="true" FileName="Block" ExportOnlyData="true" OpenInNewWindow="true"> <Excel Format="ExcelML" /> </ExportSettings> <MasterTableView CommandItemDisplay="Top" AllowMultiColumnSorting="true" FilterItemStyle-HorizontalAlign="Center"> <CommandItemSettings ShowExportToExcelButton="true" ShowExportToWordButton="false" ShowExportToPdfButton="false" ShowAddNewRecordButton="false" ShowRefreshButton="false" > </CommandItemSettings> <Columns > </Columns> </MasterTableView> <ClientSettings> <Scrolling AllowScroll="True" UseStaticHeaders="True" SaveScrollPosition="True"> </Scrolling> </ClientSettings> </telerik:RadGrid>
my cs code is
protected void grdBlock_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)
{
DataSet result = new DataSet();
BLEmployee bl_emp = new BLEmployee();
PropertyEmployeeMaster prop_emp = new PropertyEmployeeMaster();
try
{
prop_emp.Employee_Id = Convert.ToDecimal(ddlEmployeeName.SelectedItem.Value);
DateTime selectedDate = RadMonthYearPicker1.SelectedDate.Value;
DateTime startDate = selectedDate.AddDays((selectedDate.Day - 1) * -1);
DateTime endDate = startDate.AddDays(DateTime.DaysInMonth(startDate.Year, startDate.Month) - 1);
prop_emp.start_date = Convert.ToDateTime(startDate);
prop_emp.end_date = Convert.ToDateTime(endDate);
result = bl_emp.ReportMonthlyBlock(prop_emp);
result = bl_emp.ReportMonthlyBlock(prop_emp);
} function nodeClicking(sender, args) { var temp = sender._clientStateFieldID.split('_'); if (temp.length >= 1) { var name = temp[0]; var comboBox = $find(name); var node = args.get_node(); comboBox.set_text(node.get_text()); comboBox.trackChanges(); comboBox.get_items().getItem(0).set_text(node.get_text()); comboBox.get_items().getItem(0).set_value(node.get_value()); comboBox.commitChanges(); comboBox.hideDropDown(); } }<div style="width: 100%;"> <tk:RadComboBox ID="rcbState" runat="server" Width="250px" ShowToggleImage="true" EmptyMessage="Choose a State" HighlightTemplatedItems="true" style="vertical-align: middle;" > <ItemTemplate> <div id="div1"> <tk:RadTreeView ID="rtvState" runat="server" OnClientNodeClicking="nodeClicking"> <DataBindings> <tk:RadTreeNodeBinding Expanded="false" /> </DataBindings> </tk:RadTreeView> </div> </ItemTemplate> <Items> <telerik:RadComboBoxItem Text="" /> </Items> </tk:RadComboBox> <asp:Label ID="lblTest" runat="server" /> </div> <div> <tk:RadComboBox ID="rcbState2" runat="server" Width="250px" ShowToggleImage="true" EmptyMessage="Choose a State" HighlightTemplatedItems="true" style="vertical-align: middle;" > <ItemTemplate> <div id="div1"> <tk:RadTreeView ID="rtvState2" runat="server" OnClientNodeClicking="nodeClicking"> <DataBindings> <tk:RadTreeNodeBinding Expanded="false" /> </DataBindings> </tk:RadTreeView> </div> </ItemTemplate> <Items> <telerik:RadComboBoxItem Text="" /> </Items> </tk:RadComboBox> <asp:Label ID="lblTest2" runat="server" /> </div> <div> <tk:RadButton ID="btnTest" runat="server" Text="Submit" OnClick="btnTest_Click" /> </div>protected void btnTest_Click(object sender, EventArgs e) { string text = rcbState.SelectedItem.Text; string value = rcbState.SelectedItem.Value; lblTest.Text = "Name = " + text + ", ID = " + value; rcbState2.Text = text; RadTreeView rtv2 = rcbState2.Items[0].FindControl("rtvState2") as RadTreeView; (rtv2.Nodes.FindNodeByValue(value)).Expanded = true; if (rcbState2.SelectedItem != null) { lblTest2.Text = rcbState2.SelectedItem.Text; lblTest2.Text = rcbState2.SelectedItem.Value; } }