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();
}
}
}
