private void LoadEmpID() { con = new SqlConnection(ConfigurationManager.ConnectionStrings["ASPDBCS"].ConnectionString); cmd = new SqlCommand("Select Eid, Ename from Employee", con); SqlDataAdapter adpt = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); adpt.Fill(dt); DDlEmpID.DataSource = dt; DDlEmpID.DataBind(); DDlEmpID.DataTextField = "Ename"; DDlEmpID.DataValueField = "Eid"; DDlEmpID.DataBind(); con.Close(); }
protected void Page_Load(object sender, EventArgs e) { con = new SqlConnection(ConfigurationManager.ConnectionStrings["ASPDBCS"].ConnectionString); cmd = new SqlCommand(); cmd.Connection = con; if (!IsPostBack) { DDlEmpID.Items.Add(new ListItem("--Select Employee--", "")); DDlEmpID.AppendDataBoundItems = true; String strConnString = ConfigurationManager .ConnectionStrings["ASPDBCS"].ConnectionString; String strQuery = "select Eid from Advance"; SqlConnection con = new SqlConnection(strConnString); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = strQuery; cmd.Connection = con; try { con.Open(); DDlEmpID.DataSource = cmd.ExecuteReader(); DDlEmpID.DataTextField = "Eid"; DDlEmpID.DataValueField = "Eid"; DDlEmpID.DataBind(); } catch (Exception ex) { throw ex; } finally { con.Close(); con.Dispose(); } } }