显示基于下拉列表的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屋!