说明;ddlDept_name为DropDownList控件ID,ddlDept_name已经被我绑定了数据,下拉后可以显示数据,如:软件工程,通讯工程.....其AutoPostBack已设置为true,其中xueyuanView为数据库中建的一张视图,并且将select语句直接在数据库里面查询可以得到数据,但GridView不显示数据,求助,谢谢!!
protected void ddlDept_name_SelectedIndexChanged(object sender, EventArgs e)
{
string deptname = ddlDept_name.SelectedItem.Text;
DataSet ds = new DataSet();
string sConnectionString = ConfigurationManager.AppSettings["teacherConnectionString"].ToString();
using (SqlConnection conn = new SqlConnection(sConnectionString))
{
SqlDataAdapter da = new SqlDataAdapter("select * from xueyuanView where Dept_name='deptname'", conn);
da.Fill(ds);
}
gvXueyuanView.DataSource = ds;
gvXueyuanView.DataBind();
}
protected void ddlDept_name_SelectedIndexChanged(object sender, EventArgs e)
{
string deptname = ddlDept_name.SelectedItem.Text;
DataSet ds = new DataSet();
string sConnectionString = ConfigurationManager.AppSettings["teacherConnectionString"].ToString();
using (SqlConnection conn = new SqlConnection(sConnectionString))
{
SqlDataAdapter da = new SqlDataAdapter("select * from xueyuanView where Dept_name='deptname'", conn);
da.Fill(ds);
}
gvXueyuanView.DataSource = ds;
gvXueyuanView.DataBind();
}
if (!IsPostBack)
{
//
}
{
if (Session["UserName"] == null)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('请先登录!');location.href='Default.aspx'</script>");
}
else
{
lbName.Text = Session["UserName"].ToString();
}
if (!Page.IsPostBack)
{
BindSpecialty();
BindgvXueyuanview(0);
}好像ddlDept_name_SelectedIndexChanged没有写到if(!IsPostBack)里面,具体应该怎么加啊,我是菜鸟,刚开始自学,谢谢大哥大姐们了
protected void ddlDept_name_SelectedIndexChanged(object sender, EventArgs e)
{
string deptname = ddlDept_name.SelectedItem.Text;
protected void ddlDept_name_SelectedIndexChanged(object sender, EventArgs e)
{
string deptname = ddlDept_name.SelectedItem.Text;
DataSet ds = new DataSet();
string sConnectionString = ConfigurationManager.AppSettings["teacherConnectionString"].ToString();
using (SqlConnection conn = new SqlConnection(sConnectionString))
{
SqlDataAdapter da = new SqlDataAdapter("select * from xueyuanView where Dept_name='"+deptname"+'", conn);
da.Fill(ds);
}
gvXueyuanView.DataSource = ds;
gvXueyuanView.DataBind();
}