GridView Maximum Data

[Guest]

Hi,

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

Cheers

 

[chanmm]

Try it in another machine. I have try to add more 30000 rows in my
DataGridView without any problem.

chanmm

 

[Marc Gravell]

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]

Oops, I miss one zero but guess what I add another zero at the back it is
still alive though ;-)

chanmm

 

[Guest]

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?

 

[chanmm]

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

 

[Guest]

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;