Hi,
	I have a datagrid and sorting turned on.  My problem is that I do
not want the page to execute the select statement after a column header is
clicked (Sorting).  Is there a way I can store that dataset and reuse the
same one.  My data does not get updated very often.

Thanks in advance,

Ugo

Ugo,

	What you might want to do is store your dataset in the Session[]
collection, and keep it sorted there.  Are you looking for a speed gain,
have limited connections, or just want to disable column by column sorting
altogether?  If you want a speed gain or have limited connections, and the
data is accessed by multiple clients, try placing your dataset into the
Cache[] collection (this is a very nice mechanism, but items have an
expiration date and if they are not accessed are dropped from the cache -
write a buffer class in your global.asax file to catch cache exceptions and
recreate your cached datasets upon request).  If you want to disable sorting
- well its never enabled by default so I'm sure you can figure out how to
disable it. :)

	You may have to write a class that inherits from DataGrid and does
its own custom sorting (i.e. operates on a session instance of a dataset for
example).

HTH,
- Chuck

-----Original Message-----
From: Ugo Bachetti [mailto:ubachetti@h...]
Sent: Monday, May 13, 2002 11:03 AM
To: ASP+
Subject: [aspx] Datagrid


Hi,
	I have a datagrid and sorting turned on.  My problem is that I do
not want the page to execute the select statement after a column header is
clicked (Sorting).  Is there a way I can store that dataset and reuse the
same one.  My data does not get updated very often.

Thanks in advance,

Ugo