Silverlight Reloading DomainDataSource

Question

0.00/5 (No votes)

See more:

I am using an export utility to to export the contents of a datagrid in csv format.

When the page loads the grids load all data. The grids have datapagers.

When the user filter's, I want to be able to export the data using a click event.

I have a grid in the background that I am loading on the click event then exporting the contents but I'm still not getting all of the data.

How can I reload the domain datasource, then export all of the filtered results?

The following code is still only returning a portion of the data even though it's a larger set than the paged data.

Contract_Profile2DomainDataSource.Load() 
    ExpGrid.ItemsSource = Contract_Profile2DomainDataSource.Data 
    Export(dg:=ExpGrid)

Posted 19-Oct-10 8:26am

technette

Updated 19-Oct-10 9:07am

HimanshuJoshi

v2

Add a Solution

Comments

HimanshuJoshi 19-Oct-10 15:07pm

Edited for code-block

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

technette · Answer 1 · 2011-02-25T06:12:00

It took me a while to work through this solution and to resolve the problem I did the following:

1. Configured the datagrid autoload to false
2. In the XAML, configured domain datasource load size to maximum allowed. I have many datagrids in the particular application so the maximum load size varied according to size of the database tables.
3. Configured the Domain Datasource's maximum items in the Object Graph

<pre lang="xml"><behavior name="DomainService">
          <serviceMetadata httpGetEnabled="true" />
          <serviceDebug includeExceptionDetailInFaults="true" />
          <dataContractSerializer maxItemsInObjectGraph="655360" />
        </behavior>

4. Eliminated page size in the data pager
5. Enabled an apply filter button that nicely takes the user's input through a number of controls and populates the datagrids.

My export buttons works perfectly now and the user can save all of the rows in the items source in csv or excel.