Having some difficulties working with the MasterTable and the DetailTable within my Grid. I have it to the point I would like it but need some minor adjustments and I believe I have what I am looking for.
How do I get the CartID from the MasterTable passed to my DetailTable Datasource.
<telerik:RadGrid ID="_grdHistory" runat="server" AutoGenerateColumns="False" CellSpacing="0" GridLines="None"> <MasterTableView> <DetailTables> <telerik:GridTableView DataKeyNames="CartID" DataSourceID="SqlDataSource3" Width="100%" runat="server" EnableHeaderContextMenu="false"> <ParentTableRelation> <telerik:GridRelationFields DetailKeyField="CartID" MasterKeyField="CartID"> </telerik:GridRelationFields> </ParentTableRelation> <Columns> <telerik:GridBoundColumn SortExpression="CartID" HeaderText="CartID" DataField="CartID" UniqueName="CartID" Display="True"> </telerik:GridBoundColumn> <telerik:GridBoundColumn SortExpression="ItemName" HeaderText="Item Name" DataField="ItemName" UniqueName="ItemName"> </telerik:GridBoundColumn> <telerik:GridBoundColumn SortExpression="ItemCnt" HeaderText="Item Cnt" DataField="ItemCnt" UniqueName="ItemCnt"> </telerik:GridBoundColumn> <telerik:GridBoundColumn SortExpression="TotItemCost" HeaderText="Item Cnt" DataField="TotItemCost" UniqueName="TotItemCost"> </telerik:GridBoundColumn> </Columns> </telerik:GridTableView> </DetailTables> <RowIndicatorColumn Visible="True" FilterControlAltText="Filter RowIndicator column"> <HeaderStyle Width="20px"></HeaderStyle> </RowIndicatorColumn> <ExpandCollapseColumn Visible="True" FilterControlAltText="Filter ExpandColumn column"> <HeaderStyle Width="20px"></HeaderStyle> </ExpandCollapseColumn> <Columns> <telerik:GridHyperLinkColumn AllowSorting="False" FilterControlAltText="Filter InvoiceID column" HeaderText="INVOICE #" UniqueName="InvoiceID" DataNavigateUrlFields="InvoiceID" DataNavigateUrlFormatString="OrderHistoryDetail.aspx?ID={0}" DataTextField="InvoiceID" Target="_blank"> </telerik:GridHyperLinkColumn> <telerik:GridBoundColumn DataField="Order_Date" FilterControlAltText="Filter column1 column" HeaderText="ORDER DATE" UniqueName="column1" DataFormatString="{0:MM/dd/yyyy}"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Order_Amt" FilterControlAltText="Filter column1 column" HeaderText="ORDER AMOUNT" UniqueName="column1" DataFormatString="{0:c}" ItemStyle-HorizontalAlign="Right"> <ItemStyle HorizontalAlign="Right"></ItemStyle> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="OrderedByName" FilterControlAltText="Filter column1 column" HeaderText="ORDERED BY" UniqueName="column1"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Shipped" FilterControlAltText="Filter column1 column" HeaderText="SHIPPED" UniqueName="column1" DataFormatString="{0:MM/dd/yyyy}"> </telerik:GridBoundColumn> <telerik:GridHyperLinkColumn AllowSorting="False" DataTextField="FedExTrack" DataNavigateUrlFields="FedExTrack" FilterControlAltText="Filter column3 column" ImageUrl="~/images/FedEx-Shipping-Box-icon.png" DataNavigateUrlFormatString="http://www.fedex.com/Tracking?action=track&;tracknumbers={0}" UniqueName="FedExTrack" Target="_blank"> </telerik:GridHyperLinkColumn> <telerik:GridBoundColumn DataField="Approved" FilterControlAltText="Filter column1 column" UniqueName="Approved" ItemStyle-HorizontalAlign="Right" Display="False"> <ItemStyle HorizontalAlign="Right"></ItemStyle> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="CartID" FilterControlAltText="Filter CartID column" UniqueName="CartID" ItemStyle-HorizontalAlign="Right" Display="False"> <ItemStyle HorizontalAlign="Right"></ItemStyle> </telerik:GridBoundColumn> </Columns> </MasterTableView> </telerik:RadGrid> </td></tr> </table> </td> </tr></table> <asp:SqlDataSource ID="SqlDataSource3" ConnectionString="<%$ ConnectionStrings:PHConn %>" SelectCommand="sp_getCartDetail" SelectCommandType="StoredProcedure" runat="server"> <SelectParameters> <asp:ControlParameter ControlID="_grdHistory" Name="CartID" PropertyName="SelectedValue" Type="Int32" /> </SelectParameters> </asp:SqlDataSource>Also what I would like to do is if column "Approved" is NULL/blank then change the 1st column to "Pending". Likewise with FedExTrack, I would like to show it as blank and not show the image. How can I go about accomplishing these two items. Below is the code I started with but when I added the DetailTable it broke my logic.
Sub PopulateData() Try oConn.Open() Dim ocmd As New SqlCommand("sp_getOrderHistoryFilter", oConn) ocmd.CommandType = CommandType.StoredProcedure With ocmd.Parameters .Add(New SqlParameter("@asi_num", Session("asi_num"))) .Add(New SqlParameter("@Date1", DBNull.Value)) .Add(New SqlParameter("@Date2", DBNull.Value)) .Add(New SqlParameter("@Area", DBNull.Value)) End With reader = ocmd.ExecuteReader() Me._grdHistory.DataSource = reader Me._grdHistory.DataBind() Catch ex As Exception Finally oConn.Close() End TryEnd SubPrivate Sub _grdHistory_ItemDataBound(sender As Object, e As Telerik.Web.UI.GridItemEventArgs) Handles _grdHistory.ItemDataBound If TypeOf e.Item Is GridDataItem Then 'This does not appear to be working at this time. 'Purpose is to display different text if the order has not been approved yet 'If e.Item.Cells(8).Text = " " Then ' e.Item.Cells(1).Text = "Pending" ' e.Item.Cells(1).Font.Italic = True 'End If 'If e.Item.Cells(6).Text = " " Then 'Hide Shipping if there is no data ' e.Item.Cells(7).Text = "" 'End If End IfEnd Sub
i had used GridGroupByField to display some information in group header.
as i need to add a checkbox to select all node/row, i had added a checkbox column in groupheadertemplate
but all the information in group header disappear after add the groupheadertemplate.
how can i solve it ? thanks.
<telerik:RadGrid ID="RadGrid1" runat="server" AllowFilteringByColumn="True" AllowMultiRowSelection="True" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" CellSpacing="0" DataSourceID="ldsPayrollFlow" EnableAJAX="true" EnableAJAXLoadingTemplate="true" GridLines="None" LoadingTemplateTransparency="25" PageSize="100" Width="1180px"> <PagerStyle Mode="NumericPages"></PagerStyle> <mastertableview datakeynames="SID" datasourceid="ldsPayrollFlow" grouploadmode="Client"> <commanditemsettings exporttopdftext="Export to Pdf"></commanditemsettings> <rowindicatorcolumn> <HeaderStyle Width="10px"></HeaderStyle> </rowindicatorcolumn> <expandcollapsecolumn> <HeaderStyle Width="10px"></HeaderStyle> </expandcollapsecolumn> <groupbyexpressions> <telerik:GridGroupByExpression> <selectfields> <telerik:GridGroupByField FieldAlias="DisplayName" FieldName="DisplayName" HeaderText="Staff Name" HeaderValueSeparator=" : "></telerik:GridGroupByField> </selectfields> <groupbyfields> <telerik:GridGroupByField FieldName="DisplayName"></telerik:GridGroupByField> </groupbyfields> </telerik:GridGroupByExpression> </groupbyexpressions> <groupheadertemplate> <asp:CheckBox ID="GroupHeaderCheckBox" runat="server" OnClick="GroupToggleSelection(this);" ToggleType="CheckBox" ToolTip ="Select this staff"> </asp:CheckBox> <asp:Label ID="lb_staff_detail" runat="server" Text=""></asp:Label> </groupheadertemplate> <Columns> <telerik:GridBoundColumn DataField="SID" HeaderText="SID" ReadOnly="True" SortExpression="SID" UniqueName="SID" Visible="false"> </telerik:GridBoundColumn> <telerik:GridBoundColumn AllowFiltering="true" DataField="StaffNo" HeaderStyle-Width="100" HeaderText="Staff Number" ReadOnly="True" SortExpression="StaffNo" UniqueName="StaffNo"> <ItemStyle BackColor="White" BorderColor="ActiveBorder" Font-Underline="false" ForeColor="Black" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn AllowFiltering="true" DataField="DisplayName" HeaderStyle-Width="100" HeaderText="Staff Name" ReadOnly="True" SortExpression="DisplayName" UniqueName="DisplayName"><ItemStyle BackColor="White" BorderColor="ActiveBorder" Font-Underline="false" ForeColor="black" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn AllowFiltering="true" DataField="Department" HeaderStyle-Width="100" HeaderText="Department" ReadOnly="True" SortExpression="Department" UniqueName="Department"> <ItemStyle BackColor="White" BorderColor="ActiveBorder" Font-Underline="false" ForeColor="Black" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn AllowFiltering="true" DataField="BasicSalaryMonthly" ItemStyle-CssClass="cellalignRight" DataFormatString="{0:G}" HeaderStyle-Width="100" HeaderText="Basic Salary" ItemStyle-HorizontalAlign="Right" ReadOnly="True" SortExpression="BasicSalaryMonthly" UniqueName="BasicSalaryMonthly"><ItemStyle BackColor="White" BorderColor="ActiveBorder" Font-Underline="false" ForeColor="Black" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn AllowFiltering="true" DataField="AllowanceName" HeaderStyle-Width="150" HeaderText="Allowance Name" ReadOnly="True" SortExpression="AllowanceName" UniqueName="AllowanceName"><ItemStyle BackColor="White" BorderColor="ActiveBorder" Font-Underline="false" ForeColor="Black" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn AllowFiltering="true" DataField="AllowanceAmount" DataFormatString="{0:G}" HeaderStyle-Width="100" HeaderText="Amount" ItemStyle-HorizontalAlign="Right" ReadOnly="True" SortExpression="AllowanceAmount" UniqueName="AllowanceAmount"><ItemStyle BackColor="White" BorderColor="ActiveBorder" Font-Underline="false" ForeColor="Black" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn AllowFiltering="true" DataField="UpdateDate" DataFormatString="{0:dd-MMM-yyyy}" HeaderStyle-Width="100" HeaderText="Last Updated Date" ReadOnly="True" DataType="System.DateTime" SortExpression="UpdateDate" UniqueName="UpdateDate"><ItemStyle BackColor="White" BorderColor="ActiveBorder" Font-Underline="false" ForeColor="Black" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn AllowFiltering="true" DataField="FlowDate" DataFormatString="{0:dd-MMM-yyyy}" HeaderStyle-Width="100" HeaderText="Last Flow Date" ReadOnly="True" DataType="System.DateTime" SortExpression="FlowDate" UniqueName="FlowDate"><ItemStyle BackColor="White" BorderColor="ActiveBorder" Font-Underline="false" ForeColor="Black" /> </telerik:GridBoundColumn> <telerik:GridClientSelectColumn Display="false" HeaderStyle-Width="10" UniqueName="ClientSelectColumn" Visible="true"> </telerik:GridClientSelectColumn> </Columns> </mastertableview> <clientsettings> <selecting allowrowselect="true"></selecting> <ClientEvents OnRowSelecting="Selecting" /> <%-- <resizing allowcolumnresize="True" allowrowresize="True" enablerealtimeresize="True" resizegridoncolumnresize="False"></resizing>--%> </clientsettings> </telerik:RadGrid></telerik:RadAjaxPanel>
========================
VB CODE BEHIND
=========================Protected Sub cmdExportPayrolFile_Click(sender As Object, e As EventArgs) Handles cmdExportPayrolFile.Click
dgExportReport.MasterTableView.ExportToCSV()
End Sub
Am I missing something in the grid properties? Does this feature only work if the page is run from the server and NOT localhost? I am populating the grid using advanced binding upon a combo box select index changed.
Thanks
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
Setup();
}
protected void Setup()
{
DataTable oTableParent = new DataTable("Parent");
oTableParent.Columns.Add("PKey", Type.GetType("System.Int32"));
oTableParent.Columns.Add("Code", Type.GetType("System.String"));
oTableParent.Columns.Add("Description", Type.GetType("System.String"));
oTableParent.Rows.Add(1,"AAAAA","aaaaaaaaaaaaaaa");
oTableParent.Rows.Add(2,"BBBBB","bbbbbbbbbbbbbbb");
DataTable oTableChild = new DataTable("Child");
oTableChild.Columns.Add("ChildPKey", Type.GetType("System.Int32"));
oTableChild.Columns.Add("PKey", Type.GetType("System.Int32"));
oTableChild.Columns.Add("Code", Type.GetType("System.String"));
oTableChild.Columns.Add("Description", Type.GetType("System.String"));
oTableChild.Rows.Add(1,1, "AAAA-A", "aaaaaaaaaaaaaaa");
oTableChild.Rows.Add(2,1, "AAAA-B", "aaaaaaabbbbbbbb");
oTableChild.Rows.Add(3, 2, "BBBB-A", "bbbbbbbbaaaaaaa");
oTableChild.Rows.Add(4, 2, "BBBB-B", "bbbbbbbbbbbbbbb");
DataColumn[] oKeys = new DataColumn[1];
oKeys[0] = oTableParent.Columns[0];
oTableParent.PrimaryKey = oKeys;
DataSet oDS = new DataSet();
oDS.Tables.Add(oTableParent);
oDS.Tables.Add(oTableChild);
oDS.Relations.Add("Primary", oDS.Tables[0].Columns[0], oDS.Tables[1].Columns[1]);
RadGrid1.AutoGenerateColumns = false;
RadGrid1.DataSource = oDS;
RadGrid1.DataBind();
}
<telerik:RadGrid ID="RadGrid1" runat="server" AllowFilteringByColumn="True" AutoGenerateColumns="False" CellSpacing="0" GridLines="None" Height="181px" Width="1091px" AllowSorting="True" DataMember="Parent">
<ClientSettings>
<Selecting AllowRowSelect="True" />
</ClientSettings>
<MasterTableView HierarchyLoadMode="ServerBind" AutoGenerateColumns="True" DataKeyNames="PKey" DataMember="Parent">
<DetailTables>
<telerik:GridTableView runat="server" AutoGenerateColumns="True" AllowSorting="False" DataMember="Child">
<%-- <ParentTableRelation>
<telerik:GridRelationFields DetailKeyField="PKey" MasterKeyField="PKey" />
</ParentTableRelation>--%>
<ParentTableRelation>
<telerik:GridRelationFields DetailKeyField="PKey" MasterKeyField="PKey" />
</ParentTableRelation>
<Columns>
<telerik:GridBoundColumn FilterControlAltText="Filter ChildPKey column" UniqueName="ChildPKey" DataType="System.Int32" HeaderText="ChildPKey" ReadOnly="True">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="PKey" FilterControlAltText="Filter PKey column" HeaderText="PKey" UniqueName="PKeyChild" DataType="System.Int32">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Code" FilterControlAltText="Filter Code column" HeaderText="Code" UniqueName="CodeChild">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Description" FilterControlAltText="Filter Description column" HeaderText="Description" UniqueName="DescriptionChild">
</telerik:GridBoundColumn>
</Columns>
</telerik:GridTableView>
</DetailTables>
<Columns>
<telerik:GridBoundColumn DataField="PKey" FilterControlAltText="Filter PKey column" HeaderText="PKey" UniqueName="PKey" DataType="System.Int32">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Code" FilterControlAltText="Filter Code column" HeaderText="Code" UniqueName="Code">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Description" FilterControlAltText="Filter Description column" HeaderText="Description" UniqueName="Description">
</telerik:GridBoundColumn>
<telerik:GridCheckBoxColumn DataType="System.Boolean" FilterControlAltText="Filter column column" UniqueName="column">
</telerik:GridCheckBoxColumn>
</Columns>
</MasterTableView>
</telerik:RadGrid>
Gary
<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server"> <AjaxSettings> <telerik:AjaxSetting AjaxControlID="grdSoftware"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="grdSoftware" LoadingPanelID="RadAjaxLoadingPanel1" /> </UpdatedControls> </telerik:AjaxSetting> </AjaxSettings> <AjaxSettings> <telerik:AjaxSetting AjaxControlID="grdCategory"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="grdCategory" LoadingPanelID="RadAjaxLoadingPanel1" /> </UpdatedControls> </telerik:AjaxSetting> </AjaxSettings> </telerik:RadAjaxManager> <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" Skin="WebBlue"> </telerik:RadAjaxLoadingPanel><telerik:RadPanelBar ID="RadPanelBar1" runat="server" Width="980" ExpandMode="SingleExpandedItem" onclientitemcollapse="OnClientItemCollapse"> <CollapseAnimation Type="Linear" Duration="500" /> <Items><telerik:RadPanelItem Expanded="false" Text="Software Description"> <ContentTemplate> <telerik:RadGrid ID="grdSoftware" runat="server" AllowFilteringByColumn="True" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" AllowAutomaticUpdates="false" AutoGenerateDeleteColumn="True" AllowAutomaticInserts="false" ShowStatusBar="True" OnPreRender="grdSoftware_OnPreRender" OnItemDataBound="grdSoftware_ItemDataBound" OnItemCreated="grdSoftware_ItemCreated" OnItemCommand="grdSoftware_OnItemCommand" VirtualItemCount="50000" PageSize="5" GridLines="None" DataSourceID="dsSoftware" OnInsertCommand="grdSoftware_OnInsertCommand" OnUpdateCommand="grdSoftware_OnUpdateCommand" OnDeleteCommand="grdSoftware_OnDeleteCommand"> <MasterTableView AllowMultiColumnSorting="true" CommandItemDisplay="Top" DataKeyNames="SofwareId" DataSourceID="dsSoftware"> <CommandItemSettings ExportToPdfText="Export to Pdf" AddNewRecordText="Add New" AddNewRecordImageUrl="Images/AddNew.ico"> </CommandItemSettings> <RowIndicatorColumn> <HeaderStyle Width="20px"></HeaderStyle> </RowIndicatorColumn> <ExpandCollapseColumn Visible="true"> <HeaderStyle Width="20px"></HeaderStyle> </ExpandCollapseColumn> <Columns> <telerik:GridEditCommandColumn /> <telerik:GridBoundColumn DataField="SofwareId" DataType="System.Int32" HeaderText="SofwareId" ReadOnly="True" SortExpression="SofwareId" Visible="false" UniqueName="SofwareId"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="SoftwareName" HeaderText="SoftwareName" SortExpression="SoftwareName" UniqueName="SoftwareName"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Description" HeaderText="Description" Visible="false" SortExpression="Description" UniqueName="Description"> </telerik:GridBoundColumn> <telerik:GridCheckBoxColumn DataField="IsActive" DataType="System.Boolean" HeaderText="IsActive" SortExpression="IsActive" UniqueName="IsActive"> </telerik:GridCheckBoxColumn> </Columns> <EditFormSettings EditFormType="Template"> <FormTemplate> <fieldset> <table> <tbody> <tr> <td> Software Name : </td> <td> <asp:TextBox ID="txtSoftwareName" Text='<%#Bind("SoftwareName") %>' runat="server"></asp:TextBox> <asp:RequiredFieldValidator ID="RequiredFieldValidator5" runat="server" ErrorMessage="* Required" ControlToValidate="txtSoftwareName"></asp:RequiredFieldValidator> </td> <td> </td> <td> </td> </tr> <tr> <td> Description : </td> <td> <asp:TextBox ID="txtDescription" Text='<%#Bind("Description") %>' runat="server"></asp:TextBox> <asp:RequiredFieldValidator ID="RequiredFieldValidator6" runat="server" ErrorMessage="* Required" ControlToValidate="txtDescription"></asp:RequiredFieldValidator> </td> <td> </td> <td> </td> </tr> <tr> <td> Is Active : </td> <td> <asp:CheckBox ID="chkIsActive" Checked='<%# Eval("IsActive") == DBNull.Value? true : Eval("IsActive") %>' runat="server"></asp:CheckBox> </td> <td> </td> <td> </td> </tr> </tbody> </table> <table style="width: 100%"> <tr> <td align="right" colspan="2"> <asp:Button ID="Button1" Text='<%# (Container is GridEditFormInsertItem) ? "Insert" : "Update" %>' runat="server" CommandName='<%# (Container is GridEditFormInsertItem) ? "PerformInsert" : "Update" %>'> </asp:Button> <asp:Button ID="Button2" Text="Cancel" runat="server" CausesValidation="False" CommandName="Cancel"> </asp:Button> </td> </tr> </table> </fieldset> </FormTemplate> <PopUpSettings Modal="true" Width="600" /> </EditFormSettings> <PagerStyle AlwaysVisible="True" /> </MasterTableView> <PagerStyle AlwaysVisible="True" /> </telerik:RadGrid> <asp:SqlDataSource ID="dsSoftware" runat="server" ConnectionString="<%$ ConnectionStrings:TestConnectionString %>" SelectCommand="SELECT [SofwareId], [SoftwareName], [Description], [IsActive] FROM [SoftwareDetails]"> </asp:SqlDataSource> </ContentTemplate> </telerik:RadPanelItem> <telerik:RadPanelItem Expanded="false" Text="Exam Categories"> <ContentTemplate> <telerik:RadGrid ID="grdCategory" runat="server" AllowFilteringByColumn="True" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" AutoGenerateDeleteColumn="True" AllowAutomaticInserts="false" AllowAutomaticUpdates="false" ShowStatusBar="True" OnItemDataBound="grdCategory_OnItemDataBound" VirtualItemCount="50000" PageSize="5" OnItemCreated="grdCategory_ItemCreated" OnPreRender="grdCategory_OnPreRender" GridLines="None" DataSourceID="CategoryDatasource" OnInsertCommand="grdCategory_OnInsertCommand" OnUpdateCommand="grdCategory_OnUpdateCommand" OnDeleteCommand="grdCategory_OnDeleteCommand" OnItemCommand="grdCategory_OnItemCommand"> <MasterTableView AllowMultiColumnSorting="true" CommandItemDisplay="Top" DataKeyNames="CategroyId" DataSourceID="CategoryDatasource"> <CommandItemSettings ExportToPdfText="Export to Pdf" AddNewRecordText="Add New" AddNewRecordImageUrl="Images/AddNew.ico"> </CommandItemSettings> <Columns> <telerik:GridEditCommandColumn /> <telerik:GridBoundColumn DataField="CategroyId" DataType="System.Int32" HeaderText="CategroyId" ReadOnly="True" SortExpression="CategroyId" UniqueName="CategroyId" Visible="False"> </telerik:GridBoundColumn> <telerik:GridTemplateColumn DataField="CategroyName" HeaderText="Categroy Name" SortExpression="CategroyName" UniqueName="CategroyName"> <ItemTemplate> <asp:Label runat="server" ID="temp1" Text='<%#Bind("CategroyName") %>' /> </ItemTemplate> <EditItemTemplate> <asp:TextBox ID="txtCategoryName" runat="server" Text='<%#Bind("CategroyName") %>' /> <asp:RequiredFieldValidator ID="RequiredFieldValidator6" runat="server" ErrorMessage="*Required" ControlToValidate="txtCategoryName"></asp:RequiredFieldValidator> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn DataField="SoftwareId" DataType="System.Int32" HeaderText="Software" SortExpression="SoftwareId" UniqueName="SoftwareId" Visible="False"> <ItemTemplate> <asp:Label ID="Label21" runat="server" Text='<%# Bind( "SoftwareId") %>' /> </ItemTemplate> <EditItemTemplate> <asp:DropDownList ID="cmbSoftwareCategory" runat="server" DataSourceID="SqlDataSourceforSoftwareCategory" Width="310px" DataValueField="SofwareId" DataTextField="SoftwareName" /> <%--SelectedValue='<%# Bind( "SoftwareId") %>'--%> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridBoundColumn DataField="SoftwareName" HeaderText="Software Name" SortExpression="SoftwareName" ReadOnly="true" UniqueName="SoftwareName"> </telerik:GridBoundColumn> <telerik:GridTemplateColumn DataField="Description" HeaderText="Description" SortExpression="Description" UniqueName="Description" Visible="False"> <ItemTemplate> <asp:Label ID="Label25" runat="server" Text='<%#Bind("Description") %>' /> </ItemTemplate> <EditItemTemplate> <asp:TextBox ID="txtDescription" runat="server" Text='<%#Bind("Description") %>' /> <asp:RequiredFieldValidator ID="RequiredFieldValidator7" runat="server" ErrorMessage="*Required" ControlToValidate="txtDescription"></asp:RequiredFieldValidator> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn DataField="IsActive" DataType="System.Boolean" HeaderText="IsActive" SortExpression="IsActive" UniqueName="IsActive" Visible="False"> <ItemTemplate> </ItemTemplate> <EditItemTemplate> <asp:CheckBox ID="chkActive" runat="server" Checked='<%# Eval("IsActive") == DBNull.Value? true : Eval("IsActive") %>' /> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn DataField="ExamName" HeaderText="ExamName" SortExpression="ExamName" UniqueName="ExamName" Visible="False"> <ItemTemplate> </ItemTemplate> <EditItemTemplate> <asp:DropDownList ID="cmbExamCategory" runat="server" DataSourceID="SqlDataSourceforExamCategory" Width="310px" DataValueField="ExamId" DataTextField="ExamName" /> <%-- SelectedValue='<%# Bind( "ExamId") %>'--%> </EditItemTemplate> </telerik:GridTemplateColumn> </Columns> <EditFormSettings> <EditColumn ButtonType="PushButton" HeaderStyle-HorizontalAlign="Right"> <HeaderStyle HorizontalAlign="Right"></HeaderStyle> </EditColumn> </EditFormSettings> <PagerStyle AlwaysVisible="True" /> </MasterTableView> <PagerStyle AlwaysVisible="True" /> </telerik:RadGrid> <asp:SqlDataSource ID="CategoryDatasource" runat="server" ConnectionString="<%$ ConnectionStrings:TestConnectionString %>" SelectCommand="SELECT CategoryDetails.CategroyId, CategoryDetails.CategroyName, CategoryDetails.SoftwareId, SoftwareDetails.SoftwareName, CategoryDetails.Description, CategoryDetails.IsActive, ExamDetails.ExamId, ExamDetails.ExamName FROM CategoryDetails INNER JOIN SoftwareDetails ON CategoryDetails.SoftwareId = SoftwareDetails.SofwareId INNER JOIN ExamDetails ON CategoryDetails.ExamId = ExamDetails.ExamId"> </asp:SqlDataSource> <asp:SqlDataSource ID="SqlDataSourceforSoftwareCategory" runat="server" ConnectionString="<%$ ConnectionStrings:TestConnectionString %>" SelectCommand="SELECT SofwareId, SoftwareName FROM SoftwareDetails"></asp:SqlDataSource> <asp:SqlDataSource ID="SqlDataSourceforExamCategory" runat="server" ConnectionString="<%$ ConnectionStrings:TestConnectionString %>" SelectCommand="SELECT ExamId, ExamName FROM ExamDetails"></asp:SqlDataSource> </ContentTemplate> </telerik:RadPanelItem></Items></telerik:RadPanelBar >
<telerik:GridTemplateColumn DataField="DETAIL" UniqueName="DetailColumn" HeaderStyle-Width="700px"> <ItemTemplate> <asp:Panel ID="Panel1" runat="server"> <table cellpadding="0" cellspacing="0" style="font-size:9px;"> <tr> <td valign="top" style="width:80px;"><b>Projected :</b></td> <td valign="top" style="width:50px;"><%# Eval("PROJECTED") %></td> <td valign="top" style="width:80px;"><b>ACD Calls :</b></td> <td valign="top" style="width:50px;"><%# Eval("ACD_CALLS") %></td> <td valign="top" style="width:80px;"><b>Aban Calls :</b></td> <td valign="top" style="width:50px;"><%# Eval("ABAN_CALLS") %></td> </tr> <tr> <td valign="top" style="width:80px;"><b>Forcasted :</b></td> <td valign="top" style="width:50px;"><%# Eval("PROJECTED") %></td> <td valign="top" style="width:80px;"><b>ACD Time :</b></td> <td valign="top" style="width:50px;"><%# Eval("ACD_CALLS") %></td> <td valign="top" style="width:80px;"><b>Aban Time :</b></td> <td valign="top" style="width:50px;"><%# Eval("ABAN_CALLS") %></td> </tr> <tr> <td valign="top" style="width:80px;"><b>Offered :</b></td> <td valign="top" style="width:50px;"><%# Eval("PROJECTED") %></td> <td valign="top" style="width:80px;"><b>ASA :</b></td> <td valign="top" style="width:50px;"><%# Eval("ACD_CALLS") %></td> <td valign="top" style="width:80px;"><b>Aban Rate :</b></td> <td valign="top" style="width:50px;"><%# Eval("ABAN_CALLS") %></td> </tr> <tr> <td valign="top" style="width:80px;"><b>Service Level :</b></td> <td valign="top" style="width:50px;"><%# Eval("PROJECTED") %></td> <td valign="top" style="width:80px;"><b></b></td> <td valign="top" style="width:50px;"></td> <td valign="top" style="width:80px;"><b>Hold Aban Calls :</b></td> <td valign="top" style="width:50px;"></td> </tr> </table> </asp:Panel> </ItemTemplate></telerik:GridTemplateColumn>Dim dr As DataRow For Each dataItem As GridDataItem In Me.rgvMainGrid.MasterTableView.Items dr = exportTable.NewRow For Each column As GridColumn In Me.rgvMainGrid.MasterTableView.Columns If column.Display = True Then Select Case column.ColumnType Case "GridBoundColumn", "GridDropDownColumn", "GridDateTimeColumn", "GridNumericColumn", "GridCalculatedColumn" strFields = strFields + IIf(strFields = Nothing, "", ",") + column.UniqueName.ToString + "," + column.HeaderText.ToString Select Case column.DataType.ToString Case "System.String" If dataItem(column.UniqueName).Text.ToString = " " Then dr(column.UniqueName) = "" Else dr(column.UniqueName) = "'" + dataItem(column.UniqueName).Text.ToString End If Case "System.Decimal", "System.Double", "System.Single" If dataItem(column.UniqueName).Text.ToString = " " Then dr(column.UniqueName) = 0 Else dr(column.UniqueName) = FormatNumber(dataItem(column.UniqueName).Text.ToString, 2, TriState.False, TriState.False, TriState.False) End If Case "System.Int16", "System.Int32", "System.Int64", "System.Single" If dataItem(column.UniqueName).Text.ToString = " " Then dr(column.UniqueName) = 0 Else dr(column.UniqueName) = FormatNumber(dataItem(column.UniqueName).Text.ToString, 0, TriState.False, TriState.False, TriState.False) End If Case "System.DateTime" If dataItem(column.UniqueName).Text.ToString = " " Then dr(column.UniqueName) = "" Else dr(column.UniqueName) = dataItem(column.UniqueName).Text.ToString End If End Select Case "GridTemplateColumn" Case Else 'Do Nothing End Select End If Next exportTable.Rows.Add(dr) Next