protected void lbuRefresh_Click(object sender, EventArgs e)
 {
     ClearData();
     ClassProvince p = new ClassProvince();
     DataTable dt = p.GetProvince("", "");
     GridView1.DataSource = dt;
     GridView1.DataBind();
     SetViewState(dt);
 }
        protected void lbuSearch_Click(object sender, EventArgs e)
        {
            if (string.IsNullOrEmpty(txtSearchProvinceTH.Text) && string.IsNullOrEmpty(txtSearchProvinceEN.Text))
            {
                ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('กรุณากรอก คำค้นหา')", true);

                return;
            }
            else
            {
                ClassProvince p = new ClassProvince();
                DataTable dt = p.GetProvince(txtSearchProvinceTH.Text, txtSearchProvinceEN.Text);
                GridView1.DataSource = dt;
                GridView1.DataBind();
                SetViewState(dt);
            }
        }
 void BindData1()
 {
     ClassProvince p = new ClassProvince();
     DataTable dt = p.GetProvince(txtSearchProvinceTH.Text, txtSearchProvinceEN.Text);
     GridView1.DataSource = dt;
     GridView1.DataBind();
     SetViewState(dt);
 }
 void BindData()
 {
     ClassProvince p = new ClassProvince();
     DataTable dt = p.GetProvince("", "");
     GridView1.DataSource = dt;
     GridView1.DataBind();
     SetViewState(dt);
 }