How to search data from grid view using dropdownlist

Question

Hi all,
I just wanna search free and paid courses using a dropdownlist from the grd view.
But i haven't use any sqldatasource bind for the dropdown.
All
Free
Paid
I want to filter free and paid courses from a grid view

issacpal · Accepted Answer

please find the below link for the same
https://www.aspsnippets.com/Articles/Filter-GridView-Records-using-DropDownList-in-HeaderTemplate-Header-Row-in-ASPNet.aspx   http://www.aspdotnet-suresh.com/2015/03/filter-aspnet-gridview-using-dropdownlist-selection-in-csharp-vbnet.html   http://www.c-sharpcorner.com/blogs/search-gridview-by-dropdownlist-and-textbox-value1

Ravindra Singh · Answer

CREATE   PROCEDURE  [dbo].[PROCEDURENAME__SEARCHFEESSTATUS]   @ ANY  PARAMETER VALE   AS    BEGIN    IF(@FeesType= 'ALL' )   BEGIN    SELECT  COURSEID,GOAL,EXPERIENCE,COURSETYPE  FROM  YOUR  TABLE   NAME   WHERE  PUT CONDITION   END    ELSE    IF(@FeesType=FEES)   BEGIN    SELECT  COURSEID,GOAL,EXPERIENCE,COURSETYPE  FROM  YOUR  TABLE   NAME   WHERE  PUT CONDITION   END    ELSE    END    END    CALL  PROCEDURE   IN  YOUR CODE

Laxmidhar Sahoo · Answer

In my test app I take two columns and use generic list .If you use data tablee then clarify me.   My code is given below   1 - create a class for list like below class  test       {           public   string  Name {  get ;  set ; }           public   string  Cat {  get ;  set ; }       }   add the html code for grid view body >           form   id = "form1"   runat = "server" >               br   /> br   /> br   />               div >                   asp:DropDownList   ID = "ddlid"   runat = "server"   AutoPostBack = "false" >                       asp:ListItem   Value = "free" > free asp:ListItem >                        asp:ListItem   Value = "paid" > paid asp:ListItem >                   asp:DropDownList >                   asp:Button   ID = "btnsearch"   Text  = "Search"   runat = "server"   OnClick = "btnsearch_Click"   />               div >               br   /> br   /> br   />           div >         asp:GridView   ID = "Gridview1"   runat = "server" >             Columns >                 asp:TemplateField   HeaderText  = "Name" >                     ItemTemplate >                         asp:TextBox   ID = "txtname"   CssClass = "txt_Style"   Text = ' '   runat = "server" > asp:TextBox >                     ItemTemplate >                                    asp:TemplateField >                 asp:TemplateField   HeaderText = "Catagory" >                     ItemTemplate >                         asp:TextBox   ID = "txtcatagory"   Text =  ' '   runat = "server" > asp:TextBox >                     ItemTemplate >                 asp:TemplateField >             Columns >         asp:GridView >           div >           form >      body >      Below is the page behind    public  partial  class  Expandclose : System.Web.UI.Page       {           DataTable dt;           List  records;            protected   void  Page_Load( object  sender, EventArgs e)           {               showsingledatarowlinq();           }            private   void  showsingledatarowlinq()           {                records =  new  List ();               test obj =  new  test();               obj.Name =  "asdf" ;               obj.Cat =  "free" ;               records.Add(obj);               test obj1 =  new  test();               obj1.Name =  "pqrs" ;               obj1.Cat =  "paid" ;               records.Add(obj1);               Gridview1.AutoGenerateColumns =  false ;               Gridview1.DataSource = records;               Gridview1.DataBind();           }        protected   void  btnsearch_Click( object  sender, EventArgs e)           {                string  code = ddlid.SelectedValue.ToString();               var serch =  new  List  ();                foreach  (var v  in  records)               {                    if  (v.Cat == code)                       serch.Add(v);               }               Gridview1.AutoGenerateColumns =  false ;               Gridview1.DataSource = serch;               Gridview1.DataBind();           }   }

Kasuni Abegunawardana · Answer

Laxmidhar Sahoo its asp.net web forms

Laxmidhar Sahoo · Answer

hi in which platform you work