Sorting DataGrids in ASP.NET

[C]

I have a datagrid that I sort by passing in a Sort Expression to a Sub which builds a dynamic order by clause and passes this into a Stored Proc.

Do I need to make a call to my Stored Proc each time the user sorts a column?

It just means that there is a trip to the DB each time they sort.

Any advice on this is much appreciated.

Thanks,
C.

 

[Sandeep Kayal]

You can eliminate this by storing the DataSource of te DataGrid in a
ViewState object. In this way you won't need to make a trip to the database
every time.

Thanks,
Sandeep

I have a datagrid that I sort by passing in a Sort Expression to a Sub

which builds a dynamic order by clause and passes this into a Stored Proc.

 

[ashelley]

I have a datagrid that I sort by passing in a Sort Expression to a Sub which builds a dynamic order by clause and passes this into a Stored Proc.

Do I need to make a call to my Stored Proc each time the user sorts a column?

It just means that there is a trip to the DB each time they sort.

Any advice on this is much appreciated.

Thanks,
C.

The dataview object has a sort function. if you put u're data into a
dataview and then bind the dataview to the datagrid you will persist
the dataview in a session and just resort it.

-adam