protected void Page_Load(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("server=.;database=northwind;uid=sa;pwd=;");
conn.Open();
SqlDataAdapter sda = new SqlDataAdapter("select * from employees", conn);
DataSet dt = new DataSet();
sda.Fill(dt);
ddl1.DataSource = dt;
ddl1.DataTextField = "Firstname";
ddl1.DataValueField = "employeeid";
ddl1.DataBind();
conn.Close();
{
SqlConnection conn = new SqlConnection("server=.;database=northwind;uid=sa;pwd=;");
conn.Open();
SqlDataAdapter sda = new SqlDataAdapter("select * from employees", conn);
DataSet dt = new DataSet();
sda.Fill(dt);
ddl1.DataSource = dt;
ddl1.DataTextField = "Firstname";
ddl1.DataValueField = "employeeid";
ddl1.DataBind();
conn.Close();