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.DataGridPageChangedEvent Args 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.DataGridSortCommandEvent Args 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.

"steroche" wrote:

> 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.DataGridPageChangedEvent Args 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.DataGridSortCommandEvent Args 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
>
>