Try this: here ddl1 is dropdownlist and con is ur connection string to database
con.Open();
SqlCommand cmd = new SqlCommand("select e_id, e_name from emp", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
DataSet ds = new DataSet();
da.Fill(ds);
dt = ds.Tables[0];
ddl1.DataValueField = dt.Columns[0].ToString();
ddl1.DataTextField = dt.Columns[1].ToString();
ddl1.DataSource = dt;
ddl1.DataBind();
ddl1.Items.Insert(0, "--SELECT--");
con.Close();