Exporting GridViewDataColumn.CellTemplate

[Hemanth]

Hi Team,

I am trying to export Radgridview in to a CSV file and facing few issues. My RadGridView contains DataColumns which binds directly and also I am embedding CellTemplate to add new control in to my radgrid.

1. <

 

 

telerik:GridViewDataColumn Header="Postal Code" UniqueName="PostalCode" DataMemberBinding="{Binding Code}" IsReadOnly="True"/>

 

2. <

 

 

telerik:GridViewDataColumn Header="Payment" UniqueName="Payment" >

 

 

 

 

<telerik:GridViewDataColumn.CellTemplate>

 

 

 

 

<DataTemplate>

 

 

 

 

<TextBox Text="{Binding payment, Mode=TwoWay, ValidatesOnExceptions=True, NotifyOnValidationError=True, Converter={StaticResource DisplayConverter}}" BorderThickness="0" IsEnabled="{Binding Pay_ID, Converter={StaticResource IsReadOnlyConverter}, Mode=TwoWay}" />

 

 

 

 

</DataTemplate>

 

 

 

 

</telerik:GridViewDataColumn.CellTemplate>

 

 

 

 

</telerik:GridViewDataColumn>

 

Now when I export this grid I get all the data from the column with name PostalCode but for the column Payment i do not get any data. Not sure what is that I am doing incorrectly but please guide me.

Export_Click Method:

private

 

 

void Export_Click(object sender, RoutedEventArgs e)

 

{

 

 

string extension = "";

 

 

 

ExportFormat format = ExportFormat.Html;

 

 

 

string selectedItem = "Csv";

 

extension =

 

"csv";

 

format =

 

ExportFormat.Csv;

 

 

 

SaveFileDialog dialog = new SaveFileDialog();

 

dialog.DefaultExt = extension;

dialog.Filter =

 

String.Format("{1} files (*.{0})|*.{0}|All files (*.*)|*.*", extension, selectedItem);

 

dialog.FilterIndex = 1;

 

 

if (dialog.ShowDialog() == true)

 

{

 

 

using (Stream stream = dialog.OpenFile())

 

{

 

 

GridViewExportOptions exportOptions = new GridViewExportOptions();

 

exportOptions.Format = format;

exportOptions.ShowColumnFooters =

 

true;

 

exportOptions.ShowColumnHeaders =

 

true;

 

exportOptions.ShowGroupFooters =

 

true;

 

RadGridView.Export(stream, exportOptions);

}

}

}

Thanks,
Hemanth

[Yavor Georgiev]

Hi Hemanth,

 The Payment column has no DataMemberBinding set, so the RadGridView does not know which value to extract. However, seeing as how you have a custom template, perhaps it would be better to handle the ElementExporting event and override the value for that column's cells to make the exported value look like your template. You can learn more about the ElementExporting event here,

Sincerely yours,
Yavor Georgiev
the Telerik team

[Hemanth]

I modified my column like this.

 

 

 

<telerik:GridViewDataColumn Header="Payment" UniqueName="Payment" DataMemberBinding="{Binding payment}">

 

 

 

 

<telerik:GridViewDataColumn.CellTemplate>

 

 

 

 

<DataTemplate>

 

 

 

 

<TextBox Text="{Binding payment, Mode=TwoWay, ValidatesOnExceptions=True, NotifyOnValidationError=True, Converter={StaticResource DisplayConverter}}" BorderThickness="0" IsEnabled="{Binding Category_ID, Converter={StaticResource IsReadOnlyConverter}, Mode=TwoWay}" />

 

 

 

 

</DataTemplate>

 

 

 

 

</telerik:GridViewDataColumn.CellTemplate>

 

 

 

 

</telerik:GridViewDataColumn>

I added DataMemberBinding option even in the parent "<telerik:GridViewDataColumn>" tag which helped me to export directly the data. Not sure if this is a correct solution and would result any performance slag.

Thanks,
Hemanth

 

[Yavor Georgiev]

Hello Hemanth,

 This will not result in any performance lag.

Regards,
Yavor Georgiev
the Telerik team