[Solved] Hide DataKeyNames from Export

[Jon]

Hello,

I am using the export feature of RadGrid to export data to our user community in excel format.
I am setting AutoGenerateColumns to true upon export so that the ouput includes data that is not visible in the grid.
This action will cause the DataKeyNames to be included in the export output.
The DataKeyNames of the MasterTableView are of course necessary when binding data to the grid (binding to the grid is required when exporting).
I would like to hide the DataKeyNames from the export since they reference primary keys for the data and shouldn't be exposed to our users.

Since the grid must be bound before the export, how do I exclude the DataKeyNames from the excel output?

Thanks,
Jon

[Shinu]

Hello Jon,

You can hide the DataKeyName field in the grid as shown in the code below:

aspx:

<telerik:RadGrid ID="RadGrid1" DataSourceID="SqlDataSource1"  AutoGenerateColumns="true" runat="server" >
      <MasterTableView DataSourceID="SqlDataSource1" DataKeyNames="CustomerID">

c#:

protected void btnExport_Click(object sender, EventArgs e)
    {
        RadGrid1.MasterTableView.GetColumn("CustomerID").Visible = false;

        RadGrid1.ExportSettings.IgnorePaging = true;
        RadGrid1.ExportSettings.OpenInNewWindow = true;
        RadGrid1.MasterTableView.ExportToExcel();
    }

Thanks

Shinu.

[Jon]

Shinu,

That did the trick.
Thanks.