Datatable query

[AVL]

hi,
I've a requireemnt ..in which my query will pull all the data from the
database table..and binds to a grid based on some calculations.....
the count of records wil be around 700000 records....
can I store this data in datatable..and bind to the grid..

what effect will it have on the performance of the page...
can someone sayy if it's optimal way ???

 

[Cor Ligthert[MVP]]

AVL,

I have seen this question before and somebody asked you something like.

Do you know what effect it has to give 700.000 rows in a GridView ?

(And not in that reply "even if you are using paging")

Beside that it is unusable for a user, is it terrible slow because of the
behaviour of Internet pages.
(The AdoNet part is not so important in that)

Cor

 

[AVL]

Actually, I need not show all those rows in a grid view..
I need to query the data and then show the resutls...
but unfortunately I can't use sql queriees,,,
I need to pull the data and then a do a query on it...