protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string str = "server=.;database=exam;Integrated security=true";
DataSet ds=new DataSet ();
using (SqlConnection sqlCnn = new SqlConnection(str))
{
using (SqlCommand sqlCmm = new SqlCommand())
{
sqlCmm.Connection = sqlCnn;
sqlCmm.CommandText = "select name,pid from province";
SqlDataAdapter da = new SqlDataAdapter(sqlCmm);
da.Fill(ds);
}
this.DropDownList1.DataSource