Hi,

I have a SQL table that has about 1000 records and 15 columns. The DataGrid

retrieves the data from this table and displays. The problem I am having

right now is every I click the column headings for different sort order, the

process must reconnect to SQL server and retrieve the same data again. I try

to avoid the round trips by caching the table data into Session("data")

variable. In other words, the first time when the web page requested, the

data will be from SQL table. But after I had data displayed in the web page

(within DataGrid), if I want to display table in different sort order, I

want the data read from Session("data").

I don't know if Session variables can handle large  amount of data or not.

If yes, does it impact any web performance in term of memory and CPU. If no, 

do you have ideas that handles the task like I described?

Please advise.

Thanks in advance.



Timothy

Hi,



In ADO.NET the default recordset type is disconnected.So this will help us

to avoid number of trips to the server. We can also use the Datatable to

store the data's from the database to make some manipulations with the

data's.





Regards



SATHISH C.G.











-----Original Message-----

From: Tim Tran <timtran55@h...>

To: ASP+ <aspx@p...>

Date: 05 February 2001 05:50

Subject: [aspx] DataGrid Sorting, data in Session variable





>Hi,

>I have a SQL table that has about 1000 records and 15 columns. The DataGrid

>retrieves the data from this table and displays. The problem I am having

>right now is every I click the column headings for different sort order,

the

>process must reconnect to SQL server and retrieve the same data again. I

try

>to avoid the round trips by caching the table data into Session("data")

>variable. In other words, the first time when the web page requested, the

>data will be from SQL table. But after I had data displayed in the web page

>(within DataGrid), if I want to display table in different sort order, I

>want the data read from Session("data").

>I don't know if Session variables can handle large  amount of data or not.

>If yes, does it impact any web performance in term of memory and CPU. If

no,

>do you have ideas that handles the task like I described?

>Please advise.

>Thanks in advance.

>

>Timothy

>

>