We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Virtual Grid and Files

Thread ID:





39566 Jan 11,2006 05:07 PM UTC Jan 18,2006 04:11 AM UTC WinForms 5
Tags: GridControl
Chad Elliot
Asked On January 11, 2006 05:07 PM UTC

I have a table that is too large to store in memory and need a way to display the table in a grid. If I dump the data to a file (xml, csv, etc), would it be possible to use the Virtual Grid and have the file be the data source for the grid? If so, does anyone have any samples? Thanks, Chad

stanleyj [Syncfusion]
Replied On January 12, 2006 10:17 AM UTC

Hi Chad, Here is a sample with virtual grid using an xml file as data source. Best regards, Stanley

Chad Elliot
Replied On January 12, 2006 02:36 PM UTC

Thanks for the sample, but that wasn''t quite what I was looking for. The sample loads the xml file into a data set object. I need a way to read the file without using a data set object. I am developing in a Terminal Server environment and if I load the data into a dataset, it will use too much memory. I need a grid that can load partial data sets directly from a file or SQL Server without loading the entire data set into memory.

stanleyj [Syncfusion]
Replied On January 16, 2006 07:06 AM UTC

Hi Chad, Here is a little sample that simulates paging data in 200 hundred row pages. Doing this, working with 1,000,000,000 has the same effort as working with 10000 rows. Of course, the performance with be related to how fast you can load a page from your data source. In the sample, these pages are generated in code so they are done relatively quickly. The sample uses a 200-row DataTable as its virtual data source. Best Regards, Stanley

Chad Elliot
Replied On January 17, 2006 08:39 PM UTC

The link to your sample appears to be broken, but if it is the same as the Virtual Grid Tutorial from your Windows Forms Sample, it still is not what I am looking for. I understand how to make the virtual grid work when you have a data source loaded into memory. I was hoping someone might have a sample of how to pull data out of a flat file by row and column so I could use it with the virtual grid. I need help writing code to read from a file, not how to use the virtual grid. I understand that this is not the correct forum for getting help with the VB.NET language, but I was hoping someone who had used your virtual grid might have already done this.

stanleyj [Syncfusion]
Replied On January 18, 2006 04:11 AM UTC

Hi Chad, Sorry for the broken link, I have attached the VB version. Thanks, Stanley



This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon