Sort Gridview Data Based On Selection Value from Dropdown List... RSS

• • Reply
  

  jeeten09

  Member

  122 Points

  150 Posts

  Sort Gridview Data Based On Selection Value from Dropdown List...

  Mar 25, 2012 03:48 PM|LINK

  Hello All,

  I have Gridview & I want to sort it based on selection value from dropdown list.

  For Example,

  I have Dropdown List :::

  <asp:dropdownlist id="drpsort" runat="server">
  <Listitem> Won </Listitem>
  <Listitem> Lost </Listitem>
  <Listitem> On Hold </Listitem>
  </asp:dropdownlist>

  So, When any1 select Won, Gridview sorts By Won & like that for all...

  Please help me...

  Thank You...

  • Edited by jeeten09 on Mar 25, 2012 03:49 PM
• • Reply
  

  paritoshmmec

  Participant

  1555 Points

  304 Posts

  Re: Sort Gridview Data Based On Selection Value from Dropdown List...

  Mar 25, 2012 04:04 PM|LINK

  I think it should be like this:

  1. if your selecting any value from drop down  just send a query to database and sort it there accroding to selected value and rebind the grid.

  2. there should be one more dropdown containing the direction of sorting (desc and asc)

  Please let me know if it helps

  Please 'Mark as Answer' if my post helped you
  
  Thanks and Regards,
  Paritosh
• • Reply
  

  jeeten09

  Member

  122 Points

  150 Posts

  Re: Sort Gridview Data Based On Selection Value from Dropdown List...

  Mar 25, 2012 04:06 PM|LINK

  paritoshmmec

  I think it should be like this:

  1. if your selecting any value from drop down  just send a query to database and sort it there accroding to selected value and rebind the grid.

  2. there should be one more dropdown containing the direction of sorting (desc and asc)

  Please let me know if it helps

  Yeah, It will...

  But is there any easy method to do it ??? I mean for wat ur saying, I will need to do coding for all values & in my case, I have atleast 20-30 values in different dropdowns...

• • Reply
  

  paritoshmmec

  Participant

  1555 Points

  304 Posts

  Re: Sort Gridview Data Based On Selection Value from Dropdown List...

  Mar 25, 2012 04:13 PM|LINK

  use this then

  protected void DropDownList1_SelectIndexChanged(object sender, EventArgs e)
          {
              gvSorting.Sort(DropDownList1.SelectedValue, SortDirection.Ascending);
          }

  protected void gvSorting_Sorting(object sender, GridViewSortEventArgs e)
  {
      DataTable dtSortTable = gvSorting.DataSource as DataTable;
      if (dtSortTable != null)
      {
          DataView dvSortedView = new DataView(dtSortTable);
          dvSortedView.Sort = e.SortExpression + " " + getSortDirectionString(e.SortDirection);
          gvSorting.DataSource = dvSortedView;
          gvSorting.DataBind();
      }
  }
  
  private static string getSortDirectionString(SortDirection sortDireciton)
  {
      string newSortDirection = String.Empty;
      if (sortDireciton == SortDirection.Ascending)
      {
          newSortDirection = "ASC";
      }
      else
      {
          newSortDirection = "DESC";
      }
      return newSortDirection;
  }

  let me know if it works

  Please 'Mark as Answer' if my post helped you
  
  Thanks and Regards,
  Paritosh
  • Marked as answer by peter pi - msft on Mar 29, 2012 08:41 AM
• • Reply
  

  jeeten09

  Member

  122 Points

  150 Posts

  Re: Sort Gridview Data Based On Selection Value from Dropdown List...

  Mar 25, 2012 04:16 PM|LINK

  paritoshmmec

  use this then

  I think It will help me for sure...

  Thank you...

• • Reply
  

  basheerkal

  Star

  10672 Points

  2426 Posts

  Re: Sort Gridview Data Based On Selection Value from Dropdown List...

  Mar 25, 2012 06:27 PM|LINK

  Hope the DropDownList  is populated with the Field names. 

  If your Gidview is GV, its  DataSource is DS and your DropDownList is DDL

  in SelectedIndexChanged Event of  DDL  put this code.( DDL's AutoPostback is to be set as true)

  DS.SelectCommand=" SELECT * From YourTable ORDER BY  " + DDL.SelectedItem.Text" ;

  GV. DataBind();

  B

  Kindly mark this post as "Answer", if it helped you.
  
  (Talk less..Work more)
  • Edited by basheerkal on Mar 25, 2012 06:29 PM
  • Edited by basheerkal on Mar 25, 2012 06:30 PM
  • Marked as answer by peter pi - msft on Mar 29, 2012 08:42 AM