Droupdownlisi绑定SQL方法

 SqlConnection sqlconn=new SqlConnection("Server=(local);Database=  ;User Id=sa;password=;");
    sqlconn.Open();
    SqlDataAdapter   sda1=new SqlDataAdapter("select  *  from     ",sqlconn);  
    DataSet ds1=new DataSet();  
    sda1.Fill(ds1);  
    olddepname.DataSource=ds1.Tables[0].DefaultView; 
    olddepname.DataTextField=" ";  
    olddepname.DataValueField   =" ";
    olddepname.DataBind();