Export datagrid to excel and pdf in silverlight

Riddhi Valecha

13y3.6kC#

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..

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Riddhi Valecha13y ago
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..
0

Riddhi Valecha13y ago

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 Stewart13y ago
I hope the below source will help you
http://www.codeproject.com/Articles/45731/Export-Silverlight-DataGrid-to-Excel-XML-CSV
0

String
{ID=1 Name=Abc}
{ID=2 Name=Def}
{ID=3 Name=Ghi}