.NET下拉控件如何绑定同一个表里面的两列(学生和老师)
我想在 if (AccepterRole.ToString() == "全部")里面,全部可以绑定学生和老师的值,但是现在只能绑定学生的值,不知道怎么实现同时绑定这两个列,在下拉显示,我是过Select 用+连起来,但是有两个查询条件T_id和S_id,没有成功
protected void M_AccepterStudentBand()
{
this.AccepterRole = this.M_Accepter_Role.SelectedValue;
if (AccepterRole.ToString() == "全部")
{
sql = "Select S_name,S_id,T_id,T_name from S_Teacher Where T_id='" + Tid.ToString() + "'";
SqlDataReader dr = conn.ExecuteReader(sql);
this.M_Accepter.DataSource = dr;//设置数据源,用于填充控件中的项的值列表
this.M_Accepter.DataTextField = "S_name";//下拉显示出来的值
this.M_Accepter.DataValueField = "S_id";//取到的值
this.M_Accepter.DataBind();//将控件及其所有子控件绑定到指定的数据源
dr.Close();
}
else if (AccepterRole.ToString() == "导师")
{
sql = "Select T_id,T_name from S_Teacher Where S_id='" + id.ToString() + "'";
SqlDataReader dr = conn.ExecuteReader(sql);
this.M_Accepter.DataSource = dr;//设置数据源,用于填充控件中的项的值列表
this.M_Accepter.DataTextField = "T_name";//下拉显示出来的值
this.M_Accepter.DataValueField = "T_id";//取到的值
this.M_Accepter.DataBind();//将控件及其所有子控件绑定到指定的数据源
dr.Close();
}
else if (AccepterRole.ToString() == "学生")
{
sql = "Select S_name,S_id,T_id,T_name from S_Teacher Where T_id='" + Tid.ToString() + "'";
SqlDataReader dr = conn.ExecuteReader(sql);
this.M_Accepter.DataSource = dr;//设置数据源,用于填充控件中的项的值列表
this.M_Accepter.DataTextField = "S_name";//下拉显示出来的值
this.M_Accepter.DataValueField = "S_id";//取到的值
this.M_Accepter.DataBind();//将控件及其所有子控件绑定到指定的数据源
dr.Close();
}
else if (AccepterRole.ToString() == "队员")
{
sql = "Select * from S_Teacher Where S_id='" + id.ToString() + "'";
SqlDataReader dr = conn.ExecuteReader(sql);
if (dr.Read())
{
group = dr["S_group"].ToString();
}
dr.Close();
M_AccepterStudentTeamBand();
}
}