.net连接数据源以及dropdownlist的数据绑定



string conn=System.Configuration.ConfigurationManager.AppSettings["conn"].ToString();
        SqlDataAdapter myCommand=new SqlDataAdapter("select * from Province",conn);
        DataSet ds=new DataSet();
        myCommand.Fill(ds);
        DataView source=new DataView(ds.Tables[0]);
        DropDownList1.DataSource=source;
        DropDownList1.DataBind();