显示基于下拉列表的gridview [英] display gridview based on dropdownlist

问题描述

hi


i想要根据下拉列表显示gridview记录。


下拉列表中的
我必须选择部门名称， ,,所以必须显示特定的记录。



实际上只有页面加载我才能看到下拉列表而不是gridview。



当我从下拉列表中选择时，必须在gridview中显示特定记录。



请帮助谢谢

hi
i want to display gridview records based on dropdownlist.

in dropdownlist i have to select department name,,,so that particluar records must be displayed.

actually when pageloads only i can see dropdownlist not gridview.

when i select from dropdownlist,, that particular records must be displayed in gridview.

please help thanks

推荐答案

试试这个!!

Try this !!

<asp:DropDownList ID="ddl" runat="server" AutoPostBack="true" OnSelectedIndexChanged="ddl_SelectedIndexChanged">
   </asp:DropDownList>
   <asp:GridView runat="server" ID="grdview">
   </asp:GridView>

protected void Page_Load（object sender，EventArgs e）

{

if（！IsPostBack）

{

con.Open（）;

string query =从tbl_Rules选择ruleid;

SqlDataAdapter da = new SqlDataAdapter（query，con）;

con.Close（）;

DataTable dt = new DataTable（）;

da.Fill（dt ）;

ddl.DataSource = dt;

ddl.DataTextField =RuleId;

ddl.DataValueField =RuleId;

ddl.DataBind（）;

ddl.Items.Insert（0，new ListItem（---- Select ----，0））; < br $>
}

}



protected void ddl_SelectedIndexChanged（object sender，EventArgs e）

{

string query =sel来自tbl_Rules的ect ruleid其中ruleid =+ ddl.SelectedValue;

SqlDataAdapter da = new SqlDataAdapter（query，con）;

con.Close（）;

DataTable dt = new DataTable（）;

da.Fill（dt）;

grdview.DataSource = dt;

grdview .DataBind（）;

}

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
con.Open();
string query = "select ruleid from tbl_Rules";
SqlDataAdapter da = new SqlDataAdapter(query, con);
con.Close();
DataTable dt = new DataTable();
da.Fill(dt);
ddl.DataSource = dt;
ddl.DataTextField = "RuleId";
ddl.DataValueField = "RuleId";
ddl.DataBind();
ddl.Items.Insert(0, new ListItem("----Select----", "0"));
}
}

protected void ddl_SelectedIndexChanged(object sender, EventArgs e)
{
string query = "select ruleid from tbl_Rules where ruleid=" + ddl.SelectedValue;
SqlDataAdapter da = new SqlDataAdapter(query, con);
con.Close();
DataTable dt = new DataTable();
da.Fill(dt);
grdview.DataSource = dt;
grdview.DataBind();
}

dropdown_selectIndexChanged

dropdown_selectIndexChanged

{

 
SqlCommand cmd = new SqlCommand("select spec from computer where prod_name is ''"+dropdown1.SelectedValue+"'' ");
 
DataSet ds = new DataSet();
SqlDataAdapter dap = new SqlDataAdapter(cmd,con);
dap.Fill(ds,"TableName");
GridView1.DataSource = ds;
GridView1.DataMember=ds.Tables[0].tableName;
GridView1.DataBind();
con.Close();
}

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