protected void Page_Load(object sender, EventArgs e) { CheckAccount(); if (!IsPostBack) { App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); List <string> s = db.GetIdU(); IdU.DataSource = s; IdU.DataBind(); if (s.Count > 0) { IdU.SelectedIndex = 0; } IdU_SelectedIndexChanged(sender, e); } if (!IsPostBack) { App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); List <string> areas = db.GetWZAreas(); Area.DataSource = areas; Area.DataBind(); Area.SelectedIndex = 0; List <string> nodes = db.GetWZNodes(Area.SelectedValue); Node.DataSource = nodes; Node.DataBind(); Node.SelectedIndex = 0; List <string> poz = db.GetWZPozition(Area.SelectedValue, Node.SelectedValue); Pozition.DataSource = poz; Pozition.DataBind(); Pozition.SelectedIndex = 0; } if (!IsPostBack) { using (SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString())) { conn.Open(); //выбор производителя и модели SqlCommand cmd; cmd = new SqlCommand("select Manufacturer, Model from PhisicalAddr " + "where LiftID=@lift", conn); cmd.Parameters.AddWithValue("lift", LiftId.SelectedValue); SqlDataReader dr = cmd.ExecuteReader(); // dr = cmd.ExecuteReader(); if (dr.Read()) { Disp.Text = dr[0].ToString() + "-" + dr[1].ToString() + ":"; } string mf = dr[0].ToString(); string md = dr[1].ToString(); dr.Close(); } } }