how to bind database table columns to the dropdownlist

protected void Page_Load(object sender, EventArgs e)

{

SqlConnection con =new SqlConnection ();

con.connectionString="Your Connection String";

con.Open();

SqlCommand com=new SqlCommand ("select id, name from employee",con); // table name

SqlDataAdapter da=new SqlDataAdapter(com);

DataSet ds =new DataSet ();

da.Fill(ds);

DropDownList1.DataTextField = ds.Tables[0].Columns["name"].ToString();

DropDownList1.DataValueField=ds.Tables[0].Columns["id"].ToString();

DropDownList1.DataSource=ds.Tables[0];

DropDownList1.DataBind();

}