按下拉列表搜索 [英] search by dropdownlist

问题描述

我必须在下拉列表中创建一个下拉列表，当我选择一个条目并按搜索按钮时，我必须添加5个条目然后它将显示该值的所有结果并显示在gridview中。

请帮我做。

i have to make a dropdown list in wihch i have to add 5 entries when i select one entry and press search button then it will show all the result against that value and show in gridview.
please help me to do it.

推荐答案

//for Drop down list
string sql = "";//put your sql query
        DataSet ds = new DataSet();
        SqlDataAdapter da = new SqlDataAdapter(sql, cn);
        da.Fill(ds);

        if (ds.Tables[0].Rows.Count > 0)
        {
            ddl.DataSource = ds;
            ddl.DataTextField = "Name";
            ddl.DataValueField = "id";
            ddl.DataBind();  
       } 

//for button click
 protected void ibtnSearch_Click(object sender, ImageClickEventArgs e)
{
   string searchTXt=ddlComments.SelectedValue.ToString();
   
       string sql = "";//put your sql query
        DataSet ds = new DataSet();
        SqlDataAdapter da = new SqlDataAdapter(sql, cn);
        da.Fill(ds);

        if (ds.Tables[0].Rows.Count > 0)
        {
                Gridview.DataSource = ds;
                Gridview.DataBind();  
       } 
}

这篇关于按下拉列表搜索的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！