在下拉选择gridview数据应显示 [英] on dropdown selction gridview data should be shown

问题描述

我是非常新的.net。

我的情况是我在页面中有一个下拉框并且里面有员工ID。我在下拉列表下面有一个gridview已经有从数据库绑定的数据。我需要的是当我在下拉列表中选择员工ID时，应该在gridview中显示与该特定EMP ID相关的数据。如何做到这一点请提前帮助我。

I am very new bie to .net .
My scenario is i have a drop down box in page and have Employee ID''s inside it.I have a gridview below the dropdown list which is already having data binded from database. what i need is when i select employee ID in dropdown , data related to that particular EMP ID should be shown in gridview .How to do this please help me out thanks in advance.

推荐答案

在DropDownList的SelectedIndexChanged事件中编写代码：

Write code in SelectedIndexChanged event of DropDownList:

protected void DropDownList_SelectedIndexChanged(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["leave"].ConnectionString;
conn.Open();
SqlCommand cmd = new SqlCommand("select * from emp_details where Emp_id=''" + DropDownList.SelectedValue + "''", conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
}

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