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();