Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / .NET Framework / ADO.NET / January 2006

Tip: Looking for answers? Try searching our database.

Help on reading data ?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
serge calderara - 13 Jan 2006 09:13 GMT
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 - 13 Jan 2006 21:01 GMT
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/G
ridViewEx05.asp


Hope this helps...

NuTcAsE

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.