Large quantity of data

[Jason]

I am evaluating the Telerik Silverlight products for use with a business application.  One of the requirements of this application is that we provide large amounts of data to our users in a heavily customized gridview.  What I mean by large at this point is 100,000 rows with 250 columns but could grow to 1,000,000 rows in the near future.  So far, I have not been very successfull with getting a good user experience in this grid with even 10,000 rows using a ria service to provide the data.  I found a blog posting that showed how to setup some custom scrolling which seemed promising.  The scrolling property does not appear to be available with the version of the GridView that is in the current trial download.  Can someone please suggest the absolute fastest way to serve SQL data to a Silverlight application along with the best configuration of the GridView for a nice user experience with large amounts of data.  Thanks in advance.

[Vlad]

Hello Jason,

 If you refer to my blog post this actually is attached behavior - not built-in feature. 

Kind regards,
Vlad
the Telerik team

[Jason]

Thanks for the quick response.  When I add scrolling:CustomScrolling.DomainDataSource to my GridView I get an error: 'scrolling' is an undeclared prefix.  I am using the version of GridView that came with the trial download from 2 days ago  2010.2.714.1040. 

[Vlad]

Hi Jason,

 You need to register the namespace similar to the example project. I've attached latest version of this demo with server-side scrolling of almost 2 mil records. 

All the best,
Vlad
the Telerik team

[Jason]

Vlad,

Thanks you for the clarification and the code.  This works well.  Just a couple of things.  Although the code builds and runs fine my designer displays this error related to the Scrolling class:

System.NullReferenceException

Object reference not set to an instance of an object.

at Telerik.Windows.Controls.GridView.Scrolling.CustomScrolling.SizeChanged(Object sender, SizeChangedEventArgs e) in C:\Documents and Settings\jamunger\my documents\visual studio 2010\Projects\RadControlsGridDemo\RadControlsGridDemo\CustomScrolling.cs:line 76 at System.Windows.FrameworkElement.OnSizeChanged(Object sender, SizeChangedEventArgs e) at MS.Internal.JoltHelper.RaiseEvent(IntPtr target, UInt32 eventId, IntPtr coreEventArgs, UInt32 eventArgsTypeIndex)

Any thoughts on what might be causing this?

Also, I would like to allow the user to scroll one record at a time by clicking the up or down arrow on the scrollbar without waiting.  Do you think that it would be possible to tweak this code to handle that?

This is looking really close to the solution that we are looking for.

Thanks,

Jason

[Vlad]

Hi Jason,

 Please use this code to fix the design-time error:

private static void OnIsEnabledPropertyChanged(DependencyObject dependencyObject, DependencyPropertyChangedEventArgs e)

        {

            if (DesignerProperties.IsInDesignTool)

                return;

            RadGridView grid = dependencyObject as RadGridView;

            if (grid != null)

            {

                if ((bool)e.NewValue)

                {

                    grid.SizeChanged += SizeChanged;

                }

            }

        }

Unfortunately I'm not sure if MoveToPage() method of the DomainDataSource will do the work in your case - page record be record. 

Best wishes,
Vlad
the Telerik team