2012和实现下拉菜单如何在进入编辑面时下拉菜单显示的是数据库中的值.docVIP

using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data; using MySql.Data.MySqlClient; namespace Exercise1.DepMng.User { public partial class UserEdit : System.Web.UI.Page { Helper he = new Helper(); protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string userid = Request[UserID]; if (!string.IsNullOrEmpty(userid)) { Bind(userid); } } } public void Bind(string UserID) { string userid = Request[UserID]; string user_sql = select * from User where UserID= + userid + ; string pid = ; string depid = ; string rid = ; DataSet ds = he.GetDataSet(user_sql, User); txtName.Text = ds.Tables[0].Rows[0][UserName].ToString(); txtSex.Text = ds.Tables[0].Rows[0][Sex].ToString(); txtAge.Text = ds.Tables[0].Rows[0][Age].ToString(); if (ds != null ds.Tables[0].Rows.Count 0) { depid = ds.Tables[0].Rows[0][DepId].ToString(); string dep_sql = select * from Department where DepId= + depid + ; DataSet ds1 = he.GetDataSet(dep_sql, Department); if (ds1 != null ds.Tables[0].Rows.Count 0) { pid = ds1.Tables[0].Rows[0][ParentID].ToString(); string depname = select DepName from Department where DepId= + pid + ; DataSet ds2 = he.GetDataSet(depname, Department); ddlDep.DataSource = ds2; ddlDep.DataTextField = DepName; } rid = ds.Tables[0].Rows[0][RId].ToString(); string rname = select RName from Role where RId = + rid + ;