OracleConnection conn = new OracleConnection("Data Source=....;User ID=....;Password=....;"); //连接数据库的对应自己的改改 conn.Open(); OracleCommand cmd = conn.CreateCommand(); //创建查询命令 cmd.CommandText = "select 专业的字段名 from 专业表 where 院校ID=" + a + " ";//创建查询语句 OracleDataReader reader = cmd.ExecuteReader();
DataTable tbl = new DataTable(); adp.Fill(tbl); int rowCount = tbl.Rows.Count; for (int i = 1; i <= rowCount; i++) { ListItem item = new ListItem(i.ToString(), i.ToString()); 专业对应的Dropdownlist.Items.Add(item); } }
比如:http://www.cnblogs.com/insus/archive/2012/10/16/2725307.html
//数据库设置
tb_yuanxi//数据库名称
tb_yuan//学院表
ID yuan//字段名
1 音乐学院
2 体育学院
3 舞蹈学院
。
tb_xi//系表
ID xi//字段名
音乐学院 唱歌
音乐学院 拉琴
音乐学院 弹琴
体育学院 跨栏
体育学院 跑步
体育学院 下棋
。。
//下拉框设置
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<asp:DropDownList ID="ddltb_yuan" runat="server" AutoPostBack="True"
onselectedindexchanged="ddltb_yuan_SelectedIndexChanged">
</asp:DropDownList>
<asp:DropDownList ID="ddlxi" runat="server">
</asp:DropDownList>
</ContentTemplate>
</asp:UpdatePanel>
//获取数据库数据添加到下拉框显示
SqlConnection sqlcon;
string strCon = ConfigurationManager.AppSettings["conn"];
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
sqlcon = new SqlConnection(strCon);
string sqlstr = "select tb_yuan from tb_yuanxi";
SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);
DataSet myds = new DataSet();
sqlcon.Open();
myda.Fill(myds);
ddltb_yuan.DataSource= myds;
ddltb_yuan.DataValueField = "tb_yuan";
ddltb_yuan.DataBind();
string strxi = "select * from tb_xi where tb_yuan='" + ddltb_yuan.SelectedItem.Text + "'";
SqlDataAdapter mydaxi = new SqlDataAdapter(strxi, sqlcon);
DataSet mydsxi = new DataSet();
mydaxi.Fill(mydsxi);
ddlxi.DataSource = mydsxi;
ddlxi.DataValueField = "xi";
ddlxi.DataBind();
sqlcon.Close();
}//CodeGo.net/ }
protected void ddltb_yuan_SelectedIndexChanged(object sender, EventArgs e)
{
sqlcon = new SqlConnection(strCon);
string sqlstr = "select * from tb_xi where tb_yuan='" + ddltb_yuan.SelectedItem.Text+ "'";
SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);
DataSet myds = new DataSet();
sqlcon.Open();
myda.Fill(myds);
ddlxi.DataSource = myds;
ddlxi.DataValueField = "xi";
ddlxi.DataBind();
sqlcon.Close();
}
http://blog.csdn.net/asahixiao/article/details/5005340两种方法,参考
protected void Dhouse_no_SelectedIndexChanged(object sender, EventArgs e)
{
string a = 学院对应的Dropdownlist.SelectedValue;
OracleConnection conn = new OracleConnection("Data Source=....;User ID=....;Password=....;"); //连接数据库的对应自己的改改
conn.Open();
OracleCommand cmd = conn.CreateCommand(); //创建查询命令
cmd.CommandText = "select 专业的字段名 from 专业表 where 院校ID=" + a + " ";//创建查询语句
OracleDataReader reader = cmd.ExecuteReader();
DataTable tbl = new DataTable();
adp.Fill(tbl);
int rowCount = tbl.Rows.Count; for (int i = 1; i <= rowCount; i++)
{
ListItem item = new ListItem(i.ToString(), i.ToString());
专业对应的Dropdownlist.Items.Add(item);
} }