private void MyInitForUpdate() { using (SqlConnection conn = new DB().GetConnection()) { SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "select * from CatMenu order by Orders asc"; conn.Open(); SqlDataReader rd1 = cmd.ExecuteReader(); CatMenuName.DataSource = rd1; CatMenuName.DataValueField = "ID"; CatMenuName.DataTextField = "CatMenuName"; CatMenuName.DataBind(); rd1.Close(); string sql = "select * from SubMenu order by Orders asc,ID desc;select * from SubMenu where ID = @ID"; cmd.CommandText = sql; cmd.Parameters.AddWithValue("@ID", Convert.ToInt16(Request["ID"])); SqlDataReader rd = cmd.ExecuteReader(); // string CatID = rd["CatID"].ToString(); rd.NextResult(); if (rd.Read()) { SubMenuName.Text = rd["SubMenuName"].ToString(); Orders.Text = rd["Orders"].ToString(); Href.Text = rd["Href"].ToString(); string CatMenuID = rd["CatMenuID"].ToString(); if (CatMenuName.Items.FindByValue(CatMenuID) != null) { CatMenuName.ClearSelection(); CatMenuName.Items.FindByValue(CatMenuID).Selected = true; } } //读取单选框所选择的信息 int valid = Convert.ToInt32(rd["Valid"]); if (valid == 1) { true1.Checked = true; } else { false1.Checked = true; } rd.Close(); conn.Close(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["RoleID"] == null || Session["UserID"] == null) { Util.ShowMessage("用户登录超时,请重新登录!", "Login2.aspx"); } else { int RoleID = Convert.ToInt16(Session["RoleID"].ToString()); if (RoleID > 1) { Util.ShowMessage("对不起,你无权访问该页面!", "User_Center.aspx"); } else { LabelUserID.Text = Request.QueryString["ID"]; CatMenuName.Focus(); if (!String.IsNullOrEmpty(Request["ID"])) { using (SqlConnection conn = new DB().GetConnection()) { SqlCommand cmd = conn.CreateCommand(); string sql = "select * from CatMenu order by valid desc;select * from CatMenu where ID = @ID"; cmd.CommandText = sql; cmd.Parameters.AddWithValue("@ID", Convert.ToInt16(Request["ID"])); conn.Open(); SqlDataReader rd = cmd.ExecuteReader(); rd.NextResult(); if (rd.Read()) { CatMenuName.Text = rd["CatMenuName"].ToString(); Href.Text = rd["Href"].ToString(); Orders.Text = rd["Orders"].ToString(); //读取单选框所选择的信息 int valid = Convert.ToInt32(rd["Valid"]); if (valid == 1) { true1.Checked = true; } else { false1.Checked = true; } } rd.Close(); conn.Close(); } } //using (sqlconnection conn = new db().getconnection()) //{ // string sql = "select * from Cats order by ID desc"; // SqlCommand cmd = new SqlCommand(sql, conn); // conn.Open(); // SqlDataReader rd = cmd.ExecuteReader(); // cmd.Parameters.AddWithValue("@ID", Label1.Text); // rd = cmd.ExecuteReader(); // if (rd.Read()) // { // int valid = Convert.ToInt32(rd["Valid"]); // if (valid == 1) // { // true1.Checked = true; // } // else // { // false1.Checked = true; // } } } } }