Sort GridView based on dropdown selection

samanta

12y4.4k.NET

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

16 Replies

Know the answer? Post it — somebody with the same question will find it here.

Princy Gupta12y ago
Accepted 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
samanta12y ago
can you please explain with small example..
Lakshmanan Sethu Sankaranarayan12y ago
Hi Samanta, while debugging, can you please check if your datatable is populating with?
samanta12y ago
showing error

DataTable must be set prior to using DataView.
samanta12y ago
showing error

DataTable must be set prior to using DataView.
Lakshmanan Sethu Sankaranarayan12y ago
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"
samanta12y ago
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">


<%# Eval("dlr_ID")%>

<%# Eval("dlr_Name")%>
Lakshmanan Sethu Sankaranarayan12y ago
Please post your grid view definition from aspx file.
samanta12y ago

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 Sankaranarayan12y ago
Simple.Can you please paste your dropdown code ? I will make changes.
samanta12y ago
can you provide full code so that i can understand properly..
Lakshmanan Sethu Sankaranarayan12y ago
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();
samanta12y ago
my dropdown outside the Gridview control so i am not getting how to do that.
Lakshmanan Sethu Sankaranarayan12y ago
Hi Samanta, Please use the index_changed for the second dropdown and implement your logic.
samanta12y ago
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 Avhad12y ago
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