[Solved] how to hide from gridbuttocolm. to boundcolm.

[Jols]

hello to all expert in telerik control,

                      i tried to follow the tips and tricks of grids hiding a gridbuttoncolumn and showing the  boundcolumn holding the data ,
and export to excel but it wont work what was wrong there. please kindly revised or check this code that someone give it to me..
 
my codes..

 

switch (e.Item.Value)//parentroot

 

{

 

case "2"://Excel

 

 

RadMenuItem Excel = e.Item;

 

 

 

foreach (GridDataItem item in RdGridMainpage.Items)

 

{

 

string requestid = item["Request ID"].Text.ToString();

 

 

 

 

if (item.Selected == true)

 

{

 

//SendtoMicrOffice(requestid);

 

 

this.RdGridMainpage.Columns.FindByUniqueNameSafe("SubjectButton").Visible = false;

 

 

this.RdGridMainpage.Columns.FindByUniqueNameSafe("Subjectdata").Visible =true;

 

 

}

 

else

 

{

item.Visible =

false;

 

}

}

 

 

RdGridMainpage.ExportSettings.ExportOnlyData =

true;

 

RdGridMainpage.ExportSettings.IgnorePaging =

true;

 

RdGridMainpage.ExportSettings.OpenInNewWindow =

true;

 

RdGridMainpage.MasterTableView.ExportToExcel();

 

break;

and this the source,

 

 

<telerik:RadGrid ID="RdGridMainpage" runat="server" AllowPaging="True" AutoGenerateColumns="False" GridLines="None" OnItemCommand="RdGridMainpage_ItemCommand" OnItemDataBound="RdGridMainpage_ItemDataBound" Width="909px" Skin="Vista" AllowMultiRowSelection ="True" OnSelectedIndexChanged="RdGridMainpage_SelectedIndexChanged" OnNeedDataSource="RdGridMainpage_NeedDataSource" >

 

 

 

 

 

<MasterTableView DataKeyNames ="fxRequestKey" >

 

 

 

 

 

 

<PagerStyle Mode ="NumericPages" />

 

 

<RowIndicatorColumn>

 

 

 

 

 

<HeaderStyle Width="20px" />

 

 

 

 

 

</RowIndicatorColumn>

 

 

 

 

 

<ExpandCollapseColumn>

 

 

 

 

 

<HeaderStyle Width="20px" />

 

 

 

 

 

</ExpandCollapseColumn>

 

 

 

 

 

<Columns>

 

 

 

 

 

 

<telerik:GridClientSelectColumn Reorderable="False" UniqueName="ClientSelectColumn" >

 

 

 

 

 

<ItemStyle HorizontalAlign="Left" />

 

 

 

 

 

 

</telerik:GridClientSelectColumn>

 

 

 

 

 

 

<telerik:GridBoundColumn DataField="fxRequestKey" HeaderText="Request ID" UniqueName="Request ID" >

 

 

 

 

 

<ItemStyle HorizontalAlign="Left" />

 

 

 

 

 

</telerik:GridBoundColumn>

 

 

 

 

 

<telerik:GridBoundColumn DataField="fcReqCategoryName" HeaderText="Category" UniqueName="Category" >

 

 

 

 

 

<ItemStyle HorizontalAlign="Left" />

 

 

 

 

 

</telerik:GridBoundColumn>

 

 

 

 

 

<telerik:GridButtonColumn CommandName="Select" DataTextField="fcSubject" HeaderText="Subject"

 

 

UniqueName="SubjectButton" >

 

 

 

 

 

<ItemStyle HorizontalAlign="Left" />

 

 

 

 

 

</telerik:GridButtonColumn>

 

 

 

 

 

<telerik:GridBoundColumn Visible ="False" DataField="fcSubject" HeaderText="Subject" UniqueName="SubjectData" >

 

 

 

 

 

<ItemStyle HorizontalAlign="Left" />

 

 

 

 

 

</telerik:GridBoundColumn>

 

 

 

 

 

<telerik:GridBoundColumn DataField="fcRequestStatusName" HeaderText="Status" UniqueName="Status" >

 

 

 

 

 

<ItemStyle HorizontalAlign="Left" />

 

 

 

 

 

</telerik:GridBoundColumn>

 

 

 

 

 

<telerik:GridBoundColumn DataField="Stage" HeaderText="Stage" UniqueName="Stage" >

 

 

 

 

 

<ItemStyle HorizontalAlign="Left" />

 

 

 

 

 

</telerik:GridBoundColumn>

 

 

 

 

 

<telerik:GridBoundColumn DataField="Initiator" HeaderText="Initiator" UniqueName="Initiator" >

 

 

 

 

 

<ItemStyle HorizontalAlign="Left" />

 

 

 

 

 

</telerik:GridBoundColumn>

 

 

 

 

 

<telerik:GridBoundColumn DataField="Institution" HeaderText="Institution" UniqueName="Institution" >

 

 

 

 

 

<ItemStyle HorizontalAlign="Left" />

 

 

 

 

 

</telerik:GridBoundColumn>

 

 

 

 

 

<telerik:GridBoundColumn DataField="DATE" HeaderText="Date" UniqueName="Date" >

 

 

 

 

 

<ItemStyle HorizontalAlign="Left" />

 

 

 

 

 

</telerik:GridBoundColumn>

 

 

 

 

 

<telerik:GridBoundColumn DataField="AGE" HeaderText="Age" UniqueName="Age" >

 

 

 

 

 

<ItemStyle HorizontalAlign="Left" />

 

 

 

 

 

</telerik:GridBoundColumn>

 

 

 

 

 

<telerik:GridBoundColumn DataField="fxUserKeyOwner" HeaderText="Assign To" UniqueName="Assign To" >

 

 

 

 

 

<ItemStyle HorizontalAlign="Left" />

 

 

 

 

 

</telerik:GridBoundColumn>

 

 

 

 

 

</Columns>

 

 

 

 

 

 

 

</MasterTableView>

 

 

 

 

 

<ExportSettings>

 

 

 

 

 

<Pdf PaperSize ="Legal" PageHeight="14in" />

 

 

</ExportSettings>

 

 

<ClientSettings>

 

 

 

 

 

<Selecting AllowRowSelect="True" />

 

 

 

 

 

</ClientSettings>

 

 

 

 

 

<FilterMenu EnableTheming="True" Skin="Vista">

 

 

 

 

 

<CollapseAnimation Duration="200" Type="OutQuint" />

 

 

 

 

 

</FilterMenu>

 

 

 

 

 

</telerik:RadGrid><br />

sample codes is highly appreciated

thanks

 

[Shinu]

Hi Jols,

Try rebinding the Grid after setting the visibility of the GridBoundColumn and see whether it works.

CS:

foreach (GridDataItem item in RdGridMainpage.Items)
{

string requestid = item["Request ID"].Text.ToString();

if (item.Selected == true)

{

//SendtoMicrOffice(requestid);
this.RdGridMainpage.Columns.FindByUniqueNameSafe("SubjectButton").Visible = false;
this.RdGridMainpage.Columns.FindByUniqueNameSafe("Subjectdata").Visible =true;

}
else

{

item.Visible =false;
}

}
RdGridMainpage.Rebind();
RdGridMainpage.ExportSettings.ExportOnlyData =true;
RdGridMainpage.ExportSettings.IgnorePaging =true;
RdGridMainpage.ExportSettings.OpenInNewWindow =true;
RdGridMainpage.MasterTableView.ExportToExcel();

Regards
Shinu.