Sort GridView based on dropdown selection

Question

In my project i am using gridview and i want gridview data to sort based on dropdown selection item. how to achieve this?

Princy Gupta · Answer

check if the following links helps you http://forums.asp.net/t/1784918.aspx?Sort+Gridview+Data+Based+On+Selection+Value+from+Dropdown+List + http://www.codeproject.com/Questions/427866/Sorting-using-Dropdownlist-with-Gridview All the best

samanta · Answer

can you please explain with small example..

Lakshmanan Sethu · Answer

Hi Samanta while debugging can you please check if your datatable is populating with?

samanta · Answer

showing error DataTable must be set prior to using DataView.

samanta · Answer

showing error DataTable must be set prior to using DataView.

Lakshmanan Sethu · Answer

protected void cboOrder_SelectedIndexChanged(object sender EventArgs e) { SqlCommand objCommand = new SqlCommand(); objCommand.CommandText = query; objCommand.CommandType = CommandType.Text; objCommand.Connection = _databaseConnection; SqlDataAdapter objRs = new SqlDataAdapter(objCommand); DataSet objDs = new DataSet(); objRs.Fill(objDs); DataView dvItems = new DataView((DataTable)objDs.Tables[datatable1]); if (cboOrder.SelectedValue == Ascending) dvItems.Sort = Dealer Name DESC ASC; else dvItems.Sort = Dealer Name DESC; grdView.DataSource = dvItems; grdView.DataBind(); } I have changed the code and check the datatable name and replace with datatable1

samanta · Answer

Width=950 CellSpacing=1 CellPadding=0 AutoGenerateColumns=False AlternatingRowStyle-CssClass=tablesearch-resultalternaterow RowStyle-CssClass=tablesearch-resultrow RowStyle-Height=32 PagerStyle-CssClass=content HeaderStyle-CssClass=grid-header HeaderStyle-Height=35px>

Lakshmanan Sethu · Answer

Please post your grid view definition from aspx file.

samanta · Answer

Dealer Name Ascending Descending protected void cboOrder_SelectedIndexChanged(object sender EventArgs e) { SqlCommand objCommand = new SqlCommand(); objCommand.CommandText = query; objCommand.CommandType = CommandType.Text; objCommand.Connection = _databaseConnection; SqlDataAdapter objRs = new SqlDataAdapter(objCommand); DataSet objDs = new DataSet(); objRs.Fill(objDs); DataView dvItems = new DataView((DataTable)objDs.Tables[datatable1]); if (cboOrder.SelectedValue == Ascending) dvItems.Sort = Menu_Group DEALERr ASC; else dvItems.Sort = Menu_Group DEALER Number DESC; grdView.DataSource = dvItems; grdView.DataBind(); }

Lakshmanan Sethu · Answer

Simple.Can you please paste your dropdown code ? I will make changes.

samanta · Answer

can you provide full code so that i can understand properly..

Lakshmanan Sethu · Answer

Hi Please try this method in index changed of your second dropdown. DataView dvItems = new DataView (( DataTable ) ds . Tables [ datatable1 ]); if ( ddl_itemsorderby . SelectedValue == Ascending ) dvItems . Sort = Menu_Group Item_Name ASC ; else dvItems . Sort = Menu_Group Item_Name DESC ; gridview1 . DataSource = dvItems ; gridview1 . DataBind ();

samanta · Answer

my dropdown outside the Gridview control so i am not getting how to do that.

Lakshmanan Sethu · Answer

Hi Samanta Please use the index_changed for the second dropdown and implement your logic.

samanta · Answer

thanks for your reply... i have two DropDownList in that first DropDownList1 contains some items and DropDownList2 contains ascending and descending options. based on this gridview data must be sort.

Nilesh Avhad · Answer

Hi Samanta please refer the following link. http://www.codeproject.com/Questions/456134/How-to-display-data-in-a-gridview-which-selected-b Please mark as answer if it solves your problem. Regards Nilesh