This is a migrated thread and some comments may be shown as answers.

GridView with 1m records

9 Answers 110 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Leo
Top achievements
Rank 2
Leo asked on 05 Nov 2010, 05:39 PM
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?

9 Answers, 1 is accepted

Sort by
0
Vlad
Telerik team
answered on 08 Nov 2010, 08:07 AM
Hello Leo,

 Have you tried this demo?

Kind regards,
Vlad
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
0
Leo
Top achievements
Rank 2
answered on 09 Nov 2010, 12:03 PM
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.
0
Vlad
Telerik team
answered on 10 Nov 2010, 08:40 AM
Hi,

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

Kind regards,
Vlad
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
0
Leo
Top achievements
Rank 2
answered on 10 Nov 2010, 06:52 PM
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?
0
Leo
Top achievements
Rank 2
answered on 12 Nov 2010, 06:03 PM
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?
0
Leo
Top achievements
Rank 2
answered on 19 Nov 2010, 03:53 PM
Help please.
0
Leo
Top achievements
Rank 2
answered on 23 Nov 2010, 06:19 PM
hello?  sir vlad?
0
Vlad
Telerik team
answered on 25 Nov 2010, 08:21 AM
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
Browse the videos here>> to help you get started with RadControls for WPF
0
Leo
Top achievements
Rank 2
answered on 25 Nov 2010, 06:03 PM
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. 
Tags
GridView
Asked by
Leo
Top achievements
Rank 2
Answers by
Vlad
Telerik team
Leo
Top achievements
Rank 2
Share this question
or