Help on reading data ?

[Guest]

Dear all

I am building an asp.net application wich collect data from an SQL server
database.
Those data in this database can be huge with the time.

Actually, I am retriving those data through store procedure return in a
dataset object which is bind to a data grid. so all queroes are executed on
the SQL server.

When the amount of data increase, does that technique is still suitable or
is there some other tips ?

regards
serge

 

[NuTcAsE]

As the amount of data increases, the server's performance goes down as
it has to render a large amount of data. The ideal way to deal with
this is to set the data grid's page size property and let the data grid
deal with retrieving only a subset amount of data from the database.

Sample of setting data grid to use pagination...

http://msdn.microsoft.com/asp.net/default.aspx?pull=/library/en-us/dnaspp/html/GridViewEx05.asp


Hope this helps...

NuTcAsE