How To Use Sorting In Datagrid

[gopi2ks]

HI
I USE THIS below code for sorting but, when we are click sorting columns , then it will showing the next page rows also, i need only this rows only sorting
waiting for ur reply
bye

private void Sort_DataGrid(o bject source,
System.Web.UI.W ebControls.Data GridSortCommand EventArgs e)
{
SqlCommand myCommand =
new SqlCommand("SEL ECT * FROM Categories",myC onnection);
myCommand.Comma ndType = CommandType.Tex t;
SqlDataAdapter myAdapter = new SqlDataAdapter( myCommand);
DataSet ds = new DataSet();

myAdapter.Fill( ds,"Categories" );
DataView dv = new DataView(ds.Tab les["Categories "]);

// Two way sorting LOGIC

if( (numberDiv%2) == 0 )
dv.Sort = e.SortExpressio n + " " + "ASC";
else
dv.Sort = e.SortExpressio n + " " + "DESC";
numberDiv++;

myDataGrid.Data Source = dv;
myDataGrid.Data Bind();
}