Datagrid Sorting Problem
-
Hi My grid has biunded columns and it sort on ascending but not on Desc Please help me in this i think after desc it is not able to display data. Thanks Snippets of Code is given In my page Load i write ViewState["SortOrder"] = ""; public void doSortDataGridItem(object sender , System.Web.UI.WebControls.DataGridSortCommandEventArgs e) { showReportsDetails(); dvDetails =dsDataset.Tables[0].DefaultView; if(ViewState["SortOrder"].ToString() == "" || ViewState["SortOrder"].ToString) == "DESC") { // DataView Name dvDetails dvDetails .Sort = e.SortExpression; //Change history no 9 ViewState["SortExpression"]= e.SortExpression; //End Change history no 9 ViewState["SortOrder"] = "ASC"; } else { // DataView Name dvDetails dvDetails .Sort = e.SortExpression + " DESC"; //Change history no 9 ViewState["SortExpression"]= e.SortExpression + " DESC"; /End Change history no 9 ViewState["SortOrder"] = "DESC"; } dgHistory.DataBind(); }//End of this event. showReportsDetails() this is used to display data in datagrid showReportsDetails() { dsDataset=SqlHelper.ExecuteDataset(com.sConnectionString(),CommandType.StoredProcedure,"SP_Reporting1",oSqlParameter); dgHistory.DataSource=dsDataset.Tables[0].DefaultView; dgHistory.DataBind(); }
-
Hi My grid has biunded columns and it sort on ascending but not on Desc Please help me in this i think after desc it is not able to display data. Thanks Snippets of Code is given In my page Load i write ViewState["SortOrder"] = ""; public void doSortDataGridItem(object sender , System.Web.UI.WebControls.DataGridSortCommandEventArgs e) { showReportsDetails(); dvDetails =dsDataset.Tables[0].DefaultView; if(ViewState["SortOrder"].ToString() == "" || ViewState["SortOrder"].ToString) == "DESC") { // DataView Name dvDetails dvDetails .Sort = e.SortExpression; //Change history no 9 ViewState["SortExpression"]= e.SortExpression; //End Change history no 9 ViewState["SortOrder"] = "ASC"; } else { // DataView Name dvDetails dvDetails .Sort = e.SortExpression + " DESC"; //Change history no 9 ViewState["SortExpression"]= e.SortExpression + " DESC"; /End Change history no 9 ViewState["SortOrder"] = "DESC"; } dgHistory.DataBind(); }//End of this event. showReportsDetails() this is used to display data in datagrid showReportsDetails() { dsDataset=SqlHelper.ExecuteDataset(com.sConnectionString(),CommandType.StoredProcedure,"SP_Reporting1",oSqlParameter); dgHistory.DataSource=dsDataset.Tables[0].DefaultView; dgHistory.DataBind(); }
-
Hi Thanks for Reply But; What to write for ME keyword or if i write that property then where to write it.
-
Hi My grid has biunded columns and it sort on ascending but not on Desc Please help me in this i think after desc it is not able to display data. Thanks Snippets of Code is given In my page Load i write ViewState["SortOrder"] = ""; public void doSortDataGridItem(object sender , System.Web.UI.WebControls.DataGridSortCommandEventArgs e) { showReportsDetails(); dvDetails =dsDataset.Tables[0].DefaultView; if(ViewState["SortOrder"].ToString() == "" || ViewState["SortOrder"].ToString) == "DESC") { // DataView Name dvDetails dvDetails .Sort = e.SortExpression; //Change history no 9 ViewState["SortExpression"]= e.SortExpression; //End Change history no 9 ViewState["SortOrder"] = "ASC"; } else { // DataView Name dvDetails dvDetails .Sort = e.SortExpression + " DESC"; //Change history no 9 ViewState["SortExpression"]= e.SortExpression + " DESC"; /End Change history no 9 ViewState["SortOrder"] = "DESC"; } dgHistory.DataBind(); }//End of this event. showReportsDetails() this is used to display data in datagrid showReportsDetails() { dsDataset=SqlHelper.ExecuteDataset(com.sConnectionString(),CommandType.StoredProcedure,"SP_Reporting1",oSqlParameter); dgHistory.DataSource=dsDataset.Tables[0].DefaultView; dgHistory.DataBind(); }
It's easy. Because you have write: ViewState["SortOrder"] = ""; in Page load So everytime it will make if(ViewState["SortOrder"].ToString() == "") true I think you may write this in page load : if(ViewState["SortOrder"]==null) { ViewState["SortOrder"] = ""; } Hope it works.
Regards, Mayank Parmar Senior Software Engineer Amba Tech Gandhinagar, India