Groups | Blog | Home
all groups > c# > october 2006 >

c# : GridView Maximum Data


Badis
10/31/2006 11:25:01 PM
Hi,

I'm tyring to display data on my gridview but when the data Exceeds "154161"
record the gridview doesn't display it..!!?

Marc Gravell
11/1/2006 4:56:22 PM
Well, 154161 is a bit bigger than 30000...

However, for large sets like this, you (the OP) may wish to consider looking
into "virtual mode", and fetch the data as you need it. I'm not aware of any
physical limitation here, but being realistic there is a limit to what it is
sensible to push into any UI.

Marc

chanmm
11/2/2006 12:46:49 AM
Try it in another machine. I have try to add more 30000 rows in my
DataGridView without any problem.

chanmm

[quoted text, click to view]

Badis
11/2/2006 5:03:01 PM
Do U mean 3000000 record!!?
So, what could be wrong in my code because I'm getting the data from DataSet
into DataView then from dataview into my grid?




[quoted text, click to view]
chanmm
11/2/2006 8:34:16 PM
Oops, I miss one zero but guess what I add another zero at the back it is
still alive though ;-)

chanmm

[quoted text, click to view]

chanmm
11/4/2006 1:00:24 AM
Yes, I have received from SQL 2005 more than 300000 records fine just that
it take a bit of time.
Can you should me your code?

chanmm

[quoted text, click to view]

Badis
11/5/2006 5:36:02 PM
actually I'm getting the data and everything is all right when the data is
less than 150.000 but if more it doesn't show in the grid and I'm thinking
using the dataview is the problem!! here is the code


string SQLSearchText = "select here" ;
DataAdapter.SelectCommand = new sCommand(SQLSearchText, connection);
DataAdapter.Fill(dataset, "SearchResult");
myDataView.Table = dataset.Tables["SearchResult"];
myGrid.DataSource = myDataView;


[quoted text, click to view]
AddThis Social Bookmark Button