Paging and sorting

[Arne]

I have a datagrid that implements sorting. Once a click on a new page number,
my sort gets lost.

How can I combine sorting and paging?

 

[steroche]

I had that problem and i think i fixed it (changed so many different
things im not sure!) by adding using the ViewState. This is what works
for me


private void dgCusomter_PageIndexChanged(object source,
System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
dgCusomter.CurrentPageIndex = e.NewPageIndex;
ViewState["CurrentPageIndex"] = e.NewPageIndex;
dgCusomter.DataBind();

dgCusomter.SelectedIndex = -1;
dgCusomter.EditItemIndex = -1;

dgCusomter.DataBind();
}


private void dgCustomer_SortCommand(object source,
System.Web.UI.WebControls.DataGridSortCommandEventArgs e)
{
mySQLConnection sqlConn = new mySQLConnection();

this.dgGarda.CurrentPageIndex = 0;
ViewState["SortExprValue"] = e.SortExpression;

sqlComm_Customer = new SqlCommand();

sqlComm_Customer.Connection = sqlConn.GetConnection();
sqlComm_Customer.CommandText = "SELECT * FROM Customer "+
"ORDER BY "+e.SortExpression;
sqlComm_Customer.CommandType = CommandType.Text;


SqlDataAdapter daCustomer= new SqlDataAdapter(sqlComm_Customer);

daCustomer.Fill(dsCustomer);
dsCustomer.Tables[0].TableName = "Customer";
BindData();



}


Hope it does the trick!,
Steve

 

[Arne]

Steroche,
That is interesting. On sort, always take them to page one.
Arne.