I check it on P4 2.7 and 1G Ram. I load 898,000 rec to table (37 sec
with slow HD),
when the program begin binding DataTable to DataGrid or DatagridView by
doing grd.datasource=mtTable is take 100 sec!??

I'm very surprise! (it seem that DataGrid have selef data storage?)
I supose that DataGrid work is only view some current records from
Datatable.
So what is done so much time?

Mtczx.

Maybe you can better try it by hand.

I assume that there have to be a lot of references to be set, to let it
perform.

Somebody who want to show a user 898.000 rows using a Grid, is in my country
is called a Sadist.

Just my thought,

Cor

Oh!!
my q is clear, what grid biding operation do?
why is not deal only with first rows from Datatable that it's can be
view on first page?

Cor write:
that's is exectly my question, what exectly the work of binding
with all rows??


if have someone that can be explain as?

You may see the sites:

http://www.udaparts.com/devguide.htm and

http://www.udaparts.com/cursordgv.jpg

Wish they are helpful to you.



<mtczx***@yahoo.com> wrote in message
Show quoteHide quote

this a very nice to find someone that not go after Microsoft like
blind.
te disadventages of disconnected Datasource (like microsoft represent)
is clear:

*Desktop App not need it at all, remember the datatable not give us
Group by that
mean that Datatable not biuld to be Memory Database, so for what we
need it?
*if we on Web App, how we fill hole dataset from remote on slowly line?


in most cases the solution is to do all data process on remote,
and send to client tiny chunk of data that cliant need to see on his
screen.

and what about check for change by other users and refrash then on
client screen?
the only way is to deal with small chunk of data, that can be refrash.

the http://www.udaparts.com/devguide.htm Project is very nice,
but i expect to pure ADO.NET cursor with not have use with old ADO.

101VB Samples
SqlCommand slow on INSERT
Q: Whitespaces in WHERE
Connections in pool not being reused
Cascading Deletes in ADO.NET (Please Help!!!)