reg datatable

AVL

Guest

Posts: n/a

19th Jul 2008

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 ???

« How to get an handle on an out-of-process COM component ? | ajax in connected web parts.. »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
A DataTable-bound DataGridView throws a low-level Exception whencolumns are sorted, removed and re-added to the underlying DataTable.	Sath123	Microsoft Dot NET Framework Forms	1	12th May 2008 01:51 PM
DataTable -> DataView -> Sort -> DataGrid : need related DataTable index	Diamonds	Microsoft ADO .NET	4	28th Jun 2006 09:23 PM
what is the best way to make a DataTable thread safe? DataTable.AcceptChanges() will throw exception (not documented)	Ryan Liu	Microsoft C# .NET	3	7th Jun 2006 06:07 PM
Retrieving datarows using DataTable.Select method and adding it to new DataTable	C.Anand via DotNetMonster.com	Microsoft ADO .NET	4	4th Apr 2005 06:21 PM
How can I use real SQL on a DataTable? i.e. not array of rows using a filter... as in DataTable.Select	Dan V.	Microsoft C# .NET	3	1st Jul 2004 04:06 PM