protected void Page_Load(object sender, EventArgs e) { string query = "SELECT staffid,firstname,lastname,dno,street,city,zipcode FROM dbo.house"; if (!IsPostBack) { LBNotify.Items.Add("Delhi"); LBNotify.Items.Add("Chennai"); LBNotify.Items.Add("Chandigarh"); try { using (SqlConnection connection = new SqlConnection(connectionString)) { using (SqlCommand cmd = new SqlCommand(query, connection)) { connection.Open(); using (SqlDataAdapter adapter = new SqlDataAdapter(query, connection)) { adapter.Fill(ds); } } } } catch (Exception ex) { Response.Write("\n Error: " + ex); } try { DDLStaffId.DataSource = ds; DDLStaffId.DataTextField = "staffid"; DDLStaffId.DataValueField = "staffid"; DDLStaffId.DataBind(); /*LBNotify.DataSource = ds; * LBNotify.DataTextField = "city"; * LBNotify.DataValueField = "city"; * LBNotify.DataBind();*/ } catch (Exception ex) { Response.Write("\n Data Error: " + ex); } } }
protected void DDLStaffId_SelectedIndexChanged(object sender, EventArgs e) { //lbl_Display.Text += LBNotify.SelectedItem.Value.ToString(); DataSet ds = new DataSet(); string connectionString = @"Data Source=(localdb)\mssqllocaldb;Initial Catalog=master;Integrated Security=True"; try { string query = "SELECT staffid,firstname,lastname,dno,street,city,zipcode FROM dbo.house"; using (SqlConnection connection = new SqlConnection(connectionString)) { using (SqlCommand cmd = new SqlCommand(query, connection)) { connection.Open(); using (SqlDataAdapter adapter = new SqlDataAdapter(query, connection)) { adapter.Fill(ds); } } } } catch (Exception ex) { Response.Write("\n Error: " + ex); } try { DDLStaffId.DataSource = ds; DDLStaffId.DataTextField = "staffid"; DDLStaffId.DataValueField = "staffid"; DDLStaffId.DataBind(); /* * LBNotify.DataSource = ds; * LBNotify.DataTextField = "city"; * LBNotify.DataValueField = "city"; * LBNotify.DataBind();*/ } catch (Exception ex) { Response.Write("\n Data Error: " + ex); } try { //for (int i= 0;i < ds.Tables[0].Rows.Count;++i) //{ lbl_Display.Text += ds.Tables[0].Rows[Convert.ToInt32(DDLStaffId.SelectedIndex)]["staffid"].ToString() + "<br/>" + ds.Tables[0].Rows[Convert.ToInt32(DDLStaffId.SelectedIndex)]["firstname"].ToString() + "<br/>" + ds.Tables[0].Rows[Convert.ToInt32(DDLStaffId.SelectedIndex)]["lastname"].ToString() + "<br/>" + ds.Tables[0].Rows[Convert.ToInt32(DDLStaffId.SelectedIndex)]["dno"].ToString() + "<br/>" + ds.Tables[0].Rows[Convert.ToInt32(DDLStaffId.SelectedIndex)]["street"].ToString() + "<br/>" + ds.Tables[0].Rows[Convert.ToInt32(DDLStaffId.SelectedIndex)]["city"].ToString() + "<br/>" + ds.Tables[0].Rows[Convert.ToInt32(DDLStaffId.SelectedIndex)]["zipcode"].ToString() + "<br/>"; //} //Response.Write("\n Selected"); } catch (Exception ex) { Response.Write("\nDataRow Error in foreach: " + ex); } }