GridView with 1m records

[Leo]

Will loading 1m data in telerik data grid view will not consume too much memory?

Let's say PC specs is Pentium 4, 1.4GHz and memory is only 512 MB.

Will it be slow to load all data with this computer?

[Vlad]

Hello Leo,

 Have you tried this demo?

Kind regards,
Vlad
the Telerik team

[Leo]

Hi thanks for your reply.

I got another question, in your telerik radgrid control is there a way that I can not load the 1m records first and do the filter part first? Is there a method for telerik's datagrid to do that? Not loading the data first just the fields of the table and when the filter is hit that's the time it will load.

[Vlad]

Hi,

 I've attached small example application to illustrate you how to achieve your goal. 

Kind regards,
Vlad
the Telerik team

[Leo]

Hello thanks for your example, it did help alot. But I got a concern, is there an event handler for your DataGrid view that when I click Filter that's the time it will load the record? Like if I filter ID equals to 50 and hit the filter button that's the time it will show the record. Is it possible?

Update 1: Nevermind the post above, I got ti it's the filtered event. :) My last problem is the hierarchical filtering/search which the URL is below

Another question is here http://www.telerik.com/community/forums/wpf/gridview/search.aspx

Update 2: Hi I tried implemeting your code the same to a new project I got a problem. In your ItemsSource={Binding} its for Datacontext, I think I have a problem binding the DataContext to the ItemsSource? I just copied and paste your code to a new project and it's not showing up the column headers. I also declared MyObject class that has fields ID and Name. Am I doing something wrong?

Follow up question: With your given sample code, how will I bind all the records that are in my MyObject class say we have ID and Name variables? How will I populate it with records from the SQL? Is it possible?

[Leo]

Hello, how did you bind the DataContext to the ItemsSource  ? Cause in ur sample it just use DataContext and ur ItemsSource xaml only says {Binding}. And do I have to manually declare the fields in a class so it automatically displays the field in the column and the filter icon?

[Leo]

Help please.

[Leo]

hello?  sir vlad?

[Vlad]

Hi,

 I'm not sure if I understand your question. Are you asking how to populate the grid from SQL? Nothing special here - you can do it exactly in the same way as with plain ListBox. You can use EF or LINQ to SQL or even old data readers if you want - however if you want the grid to sort, page, filter, group, etc directly on the data base server you should use some LINQ provider. You can check for example this blog post. To know more about WPF data binding I suggest you to check this article. 

All the best,
Vlad
the Telerik team

[Leo]

Nope, not how to populate the DataGrid. I got confused with your simple code. You assigned the data in the DataContext and you used the DataContext to bind it to the RadGridView ItemsSource, I tried to reproduce your code with using DataContext and binded it to the ItemsSource but it did not display the Column headers or data.