Sorting DataGrid when datasource is a DataSet

[Chris Green]

I have a MyDataSet : DataSet class which contains 3 talbes and 2 data relations. This is set to a custom datagrid which can expand to show something like Users -> tickets for user -> details of ticket. I'm sure this is entirely simple, but how do I sort while keeping my dataset as the datasource? When I google they always discard the dataset and do something like:

MyDataSet ds = (MyDataSet) _dgUsers.DataSource;
DataView dv = ds.Tables[0].DefaultView;
dv.Sort = "something ASC";
_dgUsers.DataSource = dv;
_dgUsers.DataBind();

This is useless as I've just lost my dataset. I tried modifying the view of the table inside the dataset but it just gets ignored (although it remains set when I sort again):

MyDataSet ds = (MyDataSet) _dgUsers.DataSource;
DataView dv = ds.Tables[0].DefaultView;
dv.Sort = "something ASC";
_dgUsers.DataSource = ds;
_dgUsers.DataBind();

How should it be done? When I clone the DataSet it seems to work. Why is that?

[cjard]

If the grid is bound directly to the table, then you must implement the sorting in the grid. Typically we impl sorting in an intermediary such as a BindingContext (ADO.NET 2.0) that sits between the grid and the data