This is a migrated thread and some comments may be shown as answers.

How to set background color for Detail table in RAD Hierarchical Grid

3 Answers 244 Views

Grid

This is a migrated thread and some comments may be shown as answers.

Prabhu asked on 13 Feb 2012, 10:53 AM

GridBGIssue.png

hi,

Ive used hierarchical grid to display the Records of different levels. here my problem is I can set the background color for Level 1 and Level 3. as we are using GridTableView for displaying Level 2 records, there is no way to define either Grid or DIV tag. Ive also tried using CSS Class. but there is no use. I need to set the BGColor for better understanding.

<telerik:RadGrid ID="RadGrid1" OnPreRender="RadGrid1_PreRender" DataSourceID="SqlDataSource1"

runat="server" AllowSorting="True" AllowPaging="True" PageSize="5" GridLines="None"

Skin="WebBlue" ShowGroupPanel="True" OnItemCreated="RadGrid1_ItemCreated" CellSpacing="0"

AutoGenerateColumns="False" ShowFooter="true">

<PagerStyle Mode="NumericPages"></PagerStyle>

<MasterTableView DataSourceID="SqlDataSource1" DataKeyNames="RequirementID" AllowMultiColumnSorting="True"

PageSize="10">

<NestedViewTemplate>

<asp:Panel runat="server" ID="InnerContainer" CssClass="viewWrap" Visible="false">

<telerik:RadTabStrip runat="server" ID="TabStip1" MultiPageID="Multipage1" SelectedIndex="0">

<Tabs>

<telerik:RadTab runat="server" Text="Scenario" PageViewID="PageView1">

</telerik:RadTab>

<telerik:RadTab runat="server" Text="CI (42)" PageViewID="PageView2">

</telerik:RadTab>

</Tabs>

</telerik:RadTabStrip>

<telerik:RadMultiPage runat="server" ID="Multipage1" SelectedIndex="0" RenderSelectedPageOnly="false">

<telerik:RadPageView runat="server" ID="PageView1">

<div>

<asp:Label ID="Label1" Font-Bold="true" Font-Italic="true" Text='<%# Eval("RequirementID") %>'

Visible="false" runat="server" />

<telerik:RadGrid runat="server" ID="RGTestCase" DataSourceID="SqlDataSource5" Skin="WebBlue"

AllowSorting="true" ShowFooter="true">

<MasterTableView AutoGenerateColumns="False" AllowPaging="true" DataKeyNames="ScenarioID"

PageSize="5" HierarchyLoadMode="ServerOnDemand">

<DetailTables>

<telerik:GridTableView AutoGenerateColumns="false" DataKeyNames="TestCaseID" DataSourceID="SqlDataSource2"

Width="100%" PageSize="5" AllowPaging="true" CssClass="detailBorder" ItemStyle-BackColor="white" ShowFooter="true">

<ParentTableRelation>

<telerik:GridRelationFields DetailKeyField="TestCaseID" MasterKeyField="TestCaseID" />

</ParentTableRelation>

<Columns>

<telerik:GridBoundColumn DataField="TestCaseID" FilterControlAltText="Filter TestCaseID column"

HeaderText="TestCaseID" SortExpression="TestCaseID" UniqueName="TestCaseID">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Version" FilterControlAltText="Filter Version column"

HeaderText="Version" SortExpression="Version" UniqueName="Version">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="TestCaseDescription" FilterControlAltText="Filter TestCaseDescription column"

HeaderText="TestCaseDescription" SortExpression="TestCaseDescription" UniqueName="TestCaseDescription">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="ScenarioID" FilterControlAltText="Filter ScenarioID column"

HeaderText="ScenarioID" SortExpression="ScenarioID" UniqueName="ScenarioID">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="ToolName" FilterControlAltText="Filter ToolName column"

HeaderText="ToolName" ReadOnly="True" SortExpression="ToolName" UniqueName="ToolName">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="TransferType" FilterControlAltText="Filter TransferType column"

HeaderText="TransferType" SortExpression="TransferType" UniqueName="TransferType">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="CreatedDate" DataType="System.DateTime" FilterControlAltText="Filter CreatedDate column"

HeaderText="CreatedDate" SortExpression="CreatedDate" UniqueName="CreatedDate">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="CreatedBy" DataType="System.Int32" FilterControlAltText="Filter CreatedBy column"

HeaderText="CreatedBy" SortExpression="CreatedBy" UniqueName="CreatedBy">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="ModifiedyDate" DataType="System.DateTime" FilterControlAltText="Filter ModifiedyDate column"

HeaderText="ModifiedyDate" SortExpression="ModifiedyDate" UniqueName="ModifiedyDate">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="ModifiedBy" DataType="System.Int32" FilterControlAltText="Filter ModifiedBy column"

HeaderText="ModifiedBy" SortExpression="ModifiedBy" UniqueName="ModifiedBy">

</telerik:GridBoundColumn>

</Columns>

<NestedViewTemplate>

<div class="viewWrap">

<telerik:RadGrid runat="server" ID="rg" DataSourceID="SqlDataSource3" Skin="WebBlue"

AllowSorting="true" ShowFooter="true">

<MasterTableView AutoGenerateColumns="false" AllowPaging="true" DataKeyNames="DefectID"

PageSize="5" HierarchyLoadMode="ServerOnDemand">

<Columns>

<telerik:GridBoundColumn DataField="DefectID" FilterControlAltText="Filter TestCaseID column"

HeaderText="DefectID" SortExpression="DefectID" UniqueName="DefectID">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Version" FilterControlAltText="Filter Version column"

HeaderText="Version" SortExpression="Version" UniqueName="Version">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="DefectDescription" FilterControlAltText="Filter DefectDescription column"

HeaderText="DefectDescription" SortExpression="DefectDescription" UniqueName="DefectDescription">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="TestCaseID" FilterControlAltText="Filter TestCaseID column"

HeaderText="TestCaseID" SortExpression="TestCaseID" UniqueName="TestCaseID">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="ToolName" FilterControlAltText="Filter ToolName column"

HeaderText="ToolName" ReadOnly="True" SortExpression="ToolName" UniqueName="ToolName">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="TransferType" FilterControlAltText="Filter TransferType column"

HeaderText="TransferType" SortExpression="TransferType" UniqueName="TransferType">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="CreatedDate" DataType="System.DateTime" FilterControlAltText="Filter CreatedDate column"

HeaderText="CreatedDate" SortExpression="CreatedDate" UniqueName="CreatedDate">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="CreatedBy" DataType="System.Int32" FilterControlAltText="Filter CreatedBy column"

HeaderText="CreatedBy" SortExpression="CreatedBy" UniqueName="CreatedBy">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="ModifiedyDate" DataType="System.DateTime" FilterControlAltText="Filter ModifiedyDate column"

HeaderText="ModifiedyDate" SortExpression="ModifiedyDate" UniqueName="ModifiedyDate">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="ModifiedBy" DataType="System.Int32" FilterControlAltText="Filter ModifiedBy column"

HeaderText="ModifiedBy" SortExpression="ModifiedBy" UniqueName="ModifiedBy">

</telerik:GridBoundColumn>

</Columns>

</MasterTableView>

</telerik:RadGrid>

</div>

</NestedViewTemplate>

</telerik:GridTableView>

</DetailTables>

<Columns>

<telerik:GridBoundColumn DataField="ScenarioID" FilterControlAltText="Filter ScenarioID column"

HeaderText="ScenarioID" SortExpression="ScenarioID" UniqueName="ScenarioID">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Version" FilterControlAltText="Filter Version column"

HeaderText="Version" SortExpression="Version" UniqueName="Version">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="ScenarioName" FilterControlAltText="Filter ScenarioName column"

HeaderText="ScenarioName" SortExpression="ScenarioName" UniqueName="ScenarioName">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="ScenarioDescription" FilterControlAltText="Filter ScenarioDescription column"

HeaderText="ScenarioDescription" SortExpression="ScenarioDescription" UniqueName="ScenarioDescription">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="RequirementID" FilterControlAltText="Filter RequirementID column"

HeaderText="RequirementID" SortExpression="RequirementID" UniqueName="RequirementID">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="ToolName" FilterControlAltText="Filter ToolName column"

HeaderText="ToolName" ReadOnly="True" SortExpression="ToolName" UniqueName="ToolName">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="TransferType" FilterControlAltText="Filter TransferType column"

HeaderText="TransferType" SortExpression="TransferType" UniqueName="TransferType">

</telerik:GridBoundColumn>

<telerik:GridCheckBoxColumn DataField="IsDeleted" DataType="System.Boolean" FilterControlAltText="Filter IsDeleted column"

HeaderText="IsDeleted" SortExpression="IsDeleted" UniqueName="IsDeleted">

</telerik:GridCheckBoxColumn>

<telerik:GridBoundColumn DataField="CreatedDate" DataType="System.DateTime" FilterControlAltText="Filter CreatedDate column"

HeaderText="CreatedDate" SortExpression="CreatedDate" UniqueName="CreatedDate">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="CreatedBy" DataType="System.Int32" FilterControlAltText="Filter CreatedBy column"

HeaderText="CreatedBy" SortExpression="CreatedBy" UniqueName="CreatedBy">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="ModifiedyDate" DataType="System.DateTime" FilterControlAltText="Filter ModifiedyDate column"

HeaderText="ModifiedyDate" SortExpression="ModifiedyDate" UniqueName="ModifiedyDate">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="ModifiedBy" DataType="System.Int32" FilterControlAltText="Filter ModifiedBy column"

HeaderText="ModifiedBy" SortExpression="ModifiedBy" UniqueName="ModifiedBy">

</telerik:GridBoundColumn>

</Columns>

</MasterTableView>

</telerik:RadGrid>

</div>

<asp:SqlDataSource ID="SqlDataSource2" ConnectionString="<%$ ConnectionStrings:iTap_GS_DemoConnectionString %>"

SelectCommand="SELECT Attribute1 AS TestCaseID, Attribute3 AS Version, Attribute10 AS TestCaseName, Attribute11 AS TestCaseDescription, Attribute2 as ScenarioID, 'TestCase' AS ToolName, Transfertype AS TransferType, IsDeleted, WhenCreated AS CreatedDate, CreatedBy, LastChanged AS ModifiedyDate, ChangedBy AS ModifiedBy FROM ToolAttributeValue

WHERE (ToolId = 680 and Attribute2 in (5)) order by TestCaseID,Version" runat="server">

<SelectParameters>

<asp:ControlParameter ControlID="Label1" PropertyName="Text" Type="String" Name="ScenarioID" />

</SelectParameters>

</asp:SqlDataSource>

<asp:SqlDataSource ID="SqlDataSource3" ConnectionString="<%$ ConnectionStrings:iTap_GS_DemoConnectionString %>"

SelectCommand="select Attribute1 AS DefectID, Attribute3 AS Version, Attribute10 AS DefectDescription, Attribute2 as TestCaseID, 'Defect' AS ToolName, Transfertype AS TransferType, WhenCreated AS CreatedDate, CreatedBy, LastChanged AS ModifiedyDate, ChangedBy AS ModifiedBy from toolattributevalue

where (toolid=624 and Attribute2 in (10))" runat="server">

<SelectParameters>

<asp:ControlParameter ControlID="Label1" PropertyName="Text" Type="String" Name="TestCaseID" />

</SelectParameters>

</asp:SqlDataSource>

<asp:SqlDataSource ID="SqlDataSource5" ConnectionString="<%$ ConnectionStrings:iTap_GS_DemoConnectionString %>"

SelectCommand="SELECT Attribute1 AS ScenarioID, Attribute3 AS Version, Attribute10 AS ScenarioName, Attribute11 AS ScenarioDescription, Attribute2 as RequirementID, 'Scenario' AS ToolName, Transfertype AS TransferType, IsDeleted, WhenCreated AS CreatedDate, CreatedBy, LastChanged AS ModifiedyDate, ChangedBy AS ModifiedBy FROM ToolAttributeValue

WHERE (ToolId = 680 and Attribute2 in (@RequirementID)) order by ScenarioID,Version"

runat="server">

<SelectParameters>

<asp:ControlParameter ControlID="Label1" PropertyName="Text" Type="String" Name="RequirementID" />

</SelectParameters>

</asp:SqlDataSource>

</telerik:RadPageView>

<telerik:RadPageView runat="server" ID="PageView2">

<div class="contactWrap">

<telerik:RadGrid runat="server" ID="RGCI" DataSourceID="SqlDataSource4" Skin="WebBlue"

AllowSorting="true">

<MasterTableView ShowHeader="true" AutoGenerateColumns="False" AllowPaging="true"

DataKeyNames="CIID" PageSize="5" HierarchyLoadMode="ServerOnDemand">

<Columns>

<telerik:GridBoundColumn DataField="CIID" FilterControlAltText="Filter CIID column"

HeaderText="CIID" SortExpression="CIID" UniqueName="CIID">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Version" FilterControlAltText="Filter Version column"

HeaderText="Version" SortExpression="Version" UniqueName="Version">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="CI" FilterControlAltText="Filter CI column" HeaderText="CI"

SortExpression="CI" UniqueName="CI">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="RequirementID" FilterControlAltText="Filter RequirementID column"

HeaderText="RequirementID" SortExpression="RequirementID" UniqueName="RequirementID">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="ToolName" FilterControlAltText="Filter ToolName column"

HeaderText="ToolName" ReadOnly="True" SortExpression="ToolName" UniqueName="ToolName">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="TransferType" FilterControlAltText="Filter TransferType column"

HeaderText="TransferType" SortExpression="TransferType" UniqueName="TransferType">

</telerik:GridBoundColumn>

<telerik:GridCheckBoxColumn DataField="IsDeleted" DataType="System.Boolean" FilterControlAltText="Filter IsDeleted column"

HeaderText="IsDeleted" SortExpression="IsDeleted" UniqueName="IsDeleted">

</telerik:GridCheckBoxColumn>

<telerik:GridBoundColumn DataField="CreatedDate" DataType="System.DateTime" FilterControlAltText="Filter CreatedDate column"

HeaderText="CreatedDate" SortExpression="CreatedDate" UniqueName="CreatedDate">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="CreatedBy" DataType="System.Int32" FilterControlAltText="Filter CreatedBy column"

HeaderText="CreatedBy" SortExpression="CreatedBy" UniqueName="CreatedBy">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="ModifiedyDate" DataType="System.DateTime" FilterControlAltText="Filter ModifiedyDate column"

HeaderText="ModifiedyDate" SortExpression="ModifiedyDate" UniqueName="ModifiedyDate">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="ModifiedBy" DataType="System.Int32" FilterControlAltText="Filter ModifiedBy column"

HeaderText="ModifiedBy" SortExpression="ModifiedBy" UniqueName="ModifiedBy">

</telerik:GridBoundColumn>

</Columns>

</MasterTableView>

</telerik:RadGrid>

<asp:SqlDataSource ID="SqlDataSource4" ConnectionString="<%$ ConnectionStrings:iTap_GS_DemoConnectionString %>"

SelectCommand="SELECT Attribute1 AS CIID, Attribute3 AS Version, Attribute10 AS CI, Attribute2 as RequirementID, 'CI' AS ToolName, Transfertype AS TransferType, IsDeleted, WhenCreated AS CreatedDate, CreatedBy, LastChanged AS ModifiedyDate, ChangedBy AS ModifiedBy FROM ToolAttributeValue

WHERE (ToolId = 680 and Attribute2 in (@RequirementID)) ORDER BY CIID, Attribute3" runat="server">

<SelectParameters>

<asp:ControlParameter ControlID="Label1" PropertyName="Text" Type="String" Name="RequirementID" />

</SelectParameters>

</asp:SqlDataSource>

</div>

</telerik:RadPageView>

</telerik:RadMultiPage>

</asp:Panel>

</NestedViewTemplate>

<Columns>

<telerik:GridBoundColumn DataField="RequirementID" HeaderText="RequirementID" SortExpression="RequirementID"

UniqueName="RequirementID" FilterControlAltText="Filter RequirementID column">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Version" HeaderText="Version" SortExpression="Version"

UniqueName="Version" FilterControlAltText="Filter Version column">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="RequirementDescription" HeaderText="RequirementDescription"

SortExpression="RequirementDescription" UniqueName="RequirementDescription" FilterControlAltText="Filter RequirementDescription column">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="ToolName" HeaderText="ToolName" SortExpression="ToolName"

UniqueName="ToolName" FilterControlAltText="Filter ToolName column">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="TransferType" HeaderText="TransferType" SortExpression="TransferType"

UniqueName="TransferType" FilterControlAltText="Filter TransferType column">

</telerik:GridBoundColumn>

<telerik:GridCheckBoxColumn DataField="IsDeleted" HeaderText="IsDeleted" SortExpression="IsDeleted"

UniqueName="IsDeleted" DataType="System.Boolean" FilterControlAltText="Filter IsDeleted column">

</telerik:GridCheckBoxColumn>

<telerik:GridBoundColumn DataField="CreatedDate" HeaderText="CreatedDate" SortExpression="CreatedDate"

UniqueName="CreatedDate" DataType="System.DateTime" FilterControlAltText="Filter CreatedDate column">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="CreatedBy" HeaderText="CreatedBy" SortExpression="CreatedBy"

UniqueName="CreatedBy" DataType="System.Int32" FilterControlAltText="Filter CreatedBy column">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="ModifiedyDate" HeaderText="ModifiedyDate" SortExpression="ModifiedyDate"

UniqueName="ModifiedyDate" DataType="System.DateTime" FilterControlAltText="Filter ModifiedyDate column">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="ModifiedBy" HeaderText="ModifiedBy" SortExpression="ModifiedBy"

UniqueName="ModifiedBy" DataType="System.Int32" FilterControlAltText="Filter ModifiedBy column">

</telerik:GridBoundColumn>

</Columns>

</MasterTableView>

<ClientSettings AllowDragToGroup="True" />

</telerik:RadGrid>

<asp:SqlDataSource ID="SqlDataSource1" ConnectionString="<%$ ConnectionStrings:iTap_GS_DemoConnectionString %>"

SelectCommand="select Attribute1 AS RequirementID, Attribute3 AS Version, Attribute20 AS RequirementDescription, 'Requirement' AS ToolName, Transfertype AS TransferType, WhenCreated AS CreatedDate, CreatedBy, LastChanged AS ModifiedyDate, ChangedBy AS ModifiedBy from toolattributevalue where toolid=621"

runat="server"></asp:SqlDataSource>

please help me on this. Attached image for your reference.

3 Answers, 1 is accepted

answered on 13 Feb 2012, 01:01 PM

GridBGIssue-1.png

Hi,
Thanks for the Reply.

After applying the CSS, the output becomes like the attached image. I don't want to highlight the rows in Red Color. It want to have the Border in Color as defined for "Defects" Grid.

NOTE: I've applied the CSS for the MasterTableView. Under the NestedViewTemplate, I have a DIV and I am able to apply the CSS for the DIV, but that will statisfy only for Defects not for Testcase.

<MasterTableView AutoGenerateColumns="False" AllowPaging="true" DataKeyNames="ScenarioID"

PageSize="5" HierarchyLoadMode="ServerOnDemand" CssClass="classname">

<DetailTables>

<telerik:GridTableView AutoGenerateColumns="false" DataKeyNames="TestCaseID" DataSourceID="SqlDataSource2"

Width="100%" PageSize="5" AllowPaging="true" ItemStyle-BackColor="white" ShowFooter="true">

<ParentTableRelation>

<telerik:GridRelationFields DetailKeyField="TestCaseID" MasterKeyField="TestCaseID" />

</ParentTableRelation>

<Columns>

<telerik:GridBoundColumn DataField="TestCaseID" FilterControlAltText="Filter TestCaseID column"

HeaderText="TestCaseID" SortExpression="TestCaseID" UniqueName="TestCaseID">

</telerik:GridBoundColumn>

.

<telerik:GridBoundColumn DataField="ModifiedBy" DataType="System.Int32" HeaderText="ModifiedBy"

SortExpression="ModifiedBy" UniqueName="ModifiedBy">

</telerik:GridBoundColumn>

</Columns>

<NestedViewTemplate>

<div class="viewWrap">

<telerik:RadGrid runat="server" ID="rg" DataSourceID="SqlDataSource3" Skin="WebBlue"

AllowSorting="true" ShowFooter="true">

<MasterTableView AutoGenerateColumns="false" AllowPaging="true" DataKeyNames="DefectID"

PageSize="5" HierarchyLoadMode="ServerOnDemand">

<Columns>

</Columns>