protected void Page_Load(object sender, EventArgs e) { CheckAccount(); if (!string.IsNullOrEmpty(Request["id"])) { _id = Int32.Parse(Request["id"]); phAddRecord.Visible = false; phEditRecord.Visible = true; } App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); _data = db.GetEnviromentAddresses(); if (!IsPostBack) { AddAddress.DataSource = _data; AddAddress.DataBind(); EditAddress.DataSource = _data; EditAddress.DataBind(); if (_data.Count > 0) { AddAddress.SelectedIndex = 0; EditAddress.SelectedIndex = 0; } List <string> list = db.GetEnviromentType(); AddType.DataSource = list; AddType.DataBind(); AddType.SelectedIndex = 0; EditType.DataSource = list; EditType.DataBind(); EditType.SelectedIndex = 0; if (_id > 0) { using (SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString())) { conn.Open(); SqlCommand cmd = new SqlCommand("e.[Name], e.Type, ea.Address, e.[Description] from [Enviroment] e " + "join EnviromentAddresses ea on ea.Id=e.AddressId where e.Id=@id", conn); cmd.Parameters.AddWithValue("id", _id); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count > 0) { EditType.SelectedValue = dt.Rows[0]["Type"].ToString(); EditName.Text = dt.Rows[0]["Name"].ToString(); EditAddress.SelectedValue = dt.Rows[0]["Address"].ToString(); EditDescription.Text = dt.Rows[0]["Description"].ToString(); } } } } }