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

radgrid expand column problem.

1 Answer 136 Views

Grid

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

Sonia asked on 19 Aug 2011, 03:35 PM

I have rad grid on my webpage , I have hierarichal radgrid, My problem is even i have set to have only one column in detailtables, it still show all columns from my select statement of sqldatasource. Here is my grid:-

<telerik:RadGrid ID="gvEmailList" runat="server" AllowSorting="True" CellSpacing="0"

DataSourceID="SqlDataSource1" GridLines="None" ShowGroupPanel="False" Skin="Outlook">

<ClientSettings AllowDragToGroup="True" AllowExpandCollapse="true">

<Selecting AllowRowSelect="True" />

</ClientSettings>

<MasterTableView AutoGenerateColumns="False" DataKeyNames="Alert_ID" DataSourceID="SqlDataSource1">

<GroupByExpressions>

<telerik:GridGroupByExpression>

<SelectFields>

<telerik:GridGroupByField FieldAlias="Email_Subject" FieldName="Email_Subject" />

</SelectFields>

<GroupByFields>

<telerik:GridGroupByField FieldName="Email_Subject" HeaderText="Subject" />

</GroupByFields>

</telerik:GridGroupByExpression>

</GroupByExpressions>

<DetailTables>

<telerik:GridTableView DataKeyNames="Alert_ID" DataSourceID="SqlDataSource6" Width="100%"

runat="server" HierarchyLoadMode="Client" ShowHeader="false">

<ParentTableRelation>

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

</ParentTableRelation>

<Columns>

<telerik:GridTemplateColumn>

<ItemTemplate>

<asp:TextBox ID="txtBody" runat="server" TextMode="MultiLine" Height="250px" Text='<%# BIND("Email_Body") %>'

Width="100%"></asp:TextBox>

</ItemTemplate>

</telerik:GridTemplateColumn>

</Columns>

</telerik:GridTableView>

</DetailTables>

<CommandItemSettings ExportToPdfText="Export to PDF"></CommandItemSettings>

<RowIndicatorColumn FilterControlAltText="Filter RowIndicator column">

<HeaderStyle Width="20px"></HeaderStyle>

</RowIndicatorColumn>

<ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column">

<HeaderStyle Width="20px"></HeaderStyle>

</ExpandCollapseColumn>

<Columns>

<telerik:GridTemplateColumn HeaderText="">

<HeaderTemplate>

<asp:CheckBox ID="chkAll" runat="server" Text="Select All" OnCheckedChanged="chkAll_CheckedChanged"

AutoPostBack="true" />

<asp:Button ID="BtnArchive" runat="server" Text="Archive" OnClick="BtnArchiveAll_Click" />

</HeaderTemplate>

<ItemTemplate>

<asp:CheckBox ID="chkAlertID" runat="server" />

<asp:HiddenField ID="hdAlertID" runat="server" Value='<%#EVAL("ALERT_ID") %>' />

<asp:HiddenField ID="hdColorCode" runat="server" Value='<%#EVAL("Alert_Level_Color_Code") %>' />

</ItemTemplate>

</telerik:GridTemplateColumn>

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

HeaderText="Alert_State" SortExpression="Alert_State" UniqueName="Alert_State"

ItemStyle-Width="50px">

<ItemStyle Width="50px"></ItemStyle>

</telerik:GridBoundColumn>

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

HeaderText="Email_Subject" SortExpression="Email_Subject" UniqueName="Email_Subject"

ItemStyle-Width="200px">

<ItemStyle Width="200px"></ItemStyle>

</telerik:GridBoundColumn>

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

HeaderText="Email_Sender" SortExpression="Email_Sender" UniqueName="Email_Sender"

ItemStyle-Width="100px">

<ItemStyle Width="100px"></ItemStyle>

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Email_DateReceived" DataType="System.DateTime"

FilterControlAltText="Filter Email_DateReceived column" HeaderText="Email_DateReceived"

SortExpression="Email_DateReceived" UniqueName="Email_DateReceived" ItemStyle-Width="80px">

<ItemStyle Width="80px"></ItemStyle>

</telerik:GridBoundColumn>

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

HeaderText="Alert_Level_Descr" SortExpression="Alert_Level_Descr" UniqueName="Alert_Level_Descr"

ItemStyle-Width="100px">

<ItemStyle Width="100px"></ItemStyle>

</telerik:GridBoundColumn>

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

HeaderText="Alert_Source" SortExpression="Alert_Source" UniqueName="Alert_Source"

ItemStyle-Width="100px">

<ItemStyle Width="100px"></ItemStyle>

</telerik:GridBoundColumn>

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

HeaderText="Alert_Server" SortExpression="Alert_Server" UniqueName="Alert_Server">

</telerik:GridBoundColumn>

</Columns>

<EditFormSettings>

<EditColumn FilterControlAltText="Filter EditCommandColumn column">

</EditColumn>

</EditFormSettings>

</MasterTableView>

<FilterMenu EnableImageSprites="False">

</FilterMenu>

<HeaderContextMenu CssClass="GridContextMenu GridContextMenu_Default">

</HeaderContextMenu>

</telerik:RadGrid>

As you can see i just have one template column in Details Table but It shows me four more columns in addition to this column from my select statement.

radgrid expand column problem.

1 Answer, 1 is accepted