Export datagrid to excel and pdf in silverlight

Question

Hi all...

How do we export the data from datagrid to excel and pdf files in Silverlight??

I have been trying this since long, but failed.

Please help.

This is urgently required...

Thanks all in advance..

Riddhi Valecha · Answer

I am facing problems with - -------------- System.Security.SecurityException:Dialogs must be user-initiated. at System.windows.controls.SaveFileDialog.ShowDialogInternal(Window owner) ---------------- I am unable to solve this issue. This is is SaveFileDialog() method(boolean method). Datagrid Data looks like - String {ID=1 Name=Abc} {ID=2 Name=Def} {ID=3 Name=Ghi} Please help.... this is urgently required... Please help.. Thanks all in advance..

Riddhi Valecha · Answer

Hi... i tried this code.. SaveFileDialog objSFD = new SaveFileDialog() { DefaultExt = "csv" , Filter = "CSV Files (*.csv)|*.csv|Excel XML (*.xml)|*.xml|All files (*.*)|*.*" , FilterIndex = 1 }; if (objSFD.ShowDialog() == true ) {} There is an error in the IF-Condition - System.SecuritySettings - dialogs must be user intiated.. ---------------- My Requirement - I have an IList MEthod() in Silverlight.svc.cs file. I have 1linq query in it. I have loaded that in the gridview. Now, I want to export it. ---

Sean Stewart · Answer

I hope the below source will help you http://www.codeproject.com/Articles/45731/Export-Silverlight-DataGrid-to-Excel-XML-CSV