Help on reading data ?

microsoft.public.dotnet.framework.adonet

13 Jan 2006 9:13 AM

serge calderara

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

13 Jan 2006 9:01 PM

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