GridView Loads Failed

[A]

Hello Telerik Team,

When I try to load a large data table into my RadGridView, it does not display anything. Could you please tell me what would be the potential reason for this?

Thanks and Regards,

Chris

[Maya]

Hi A,

Please give us more details about your scenario and requirements. It would be great if you could send us a sample project so that we can see your exact settings.
 

Best wishes,
Maya
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[A]

Dear Telerik Team,

Thanks for your reply. Basically, I just followed the video tutorial on Telerik TV: http://tv.telerik.com/watch/silverlight/webinar/working-with-telerik-gridview-dock-chart-silverlight.

In my silverlight application, I had a simple web service which returns a list of records of a table in database. Meanwhile, in the Mainpage.xaml.cs, I had a RadGridView which displays the list of records using "Loaded" event handler:

public partial class MainPage : UserControl
    {
        public MainPage()
        {
            InitializeComponent();
            Loaded +=new RoutedEventHandler(MainPage_Loaded);
        }

        void MainPage_Loaded(object sender, RoutedEventArgs e)
        {
            var proxy = new ServiceReference1.DemoSvcClient();
            proxy.DoWorkCompleted += new    EventHandler<ServiceReference1.DoWorkCompletedEventArgs>(proxy_DoWorkCompleted);
            proxy.DoWorkAsync();
        }

        void proxy_DoWorkCompleted(object sender, ServiceReference1.DoWorkCompletedEventArgs e)
        {
            radDataPager.Source = e.Result;
        }
    }

The problem was that the table is very large which contains nearly 1 million records. When I ran the application, it does not load up properly. When I changed to come smaller database, it works well. Could you please tell me why is this happening? Or is there any other ways to achieve this?

Thanks and Regards,

Chris

[Vlad]

Hello Chris,

 I'm afraid that the framework will unable to serialize such amount of data at once! You need to use server-side paging for example with WCF RIA Services or implement your own similar to this blog post. 

Sincerely yours,
Vlad
the Telerik team