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 · 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 COURSEIDGOALEXPERIENCECOURSETYPE FROM YOUR TABLE NAME WHERE PUT CONDITION END ELSE IF(@FeesType=FEES) BEGIN SELECT COURSEIDGOALEXPERIENCECOURSETYPE 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