protected void Submit_Click(object sender, EventArgs e)
    {
        string    id  = Request.QueryString["selectclientid"];
        ClientDal dal = new ClientDal();

        //if (string.IsNullOrEmpty(this.Class.Text))
        //{
        //    classname = "";
        //}
        //else
        //{
        //    classname = this.Class.Text;
        //}

        //if (string.IsNullOrEmpty(this.Serial.Text))
        //{
        //    serial = "";
        //}
        //else
        //{
        //    serial = this.Serial.Text;
        //}

        //if (string.IsNullOrEmpty(this.Client.Text))
        //{
        //    client = "";
        //}
        //else
        //{
        //    client = this.Client.Text;
        //}

        //if (string.IsNullOrEmpty(this.Tel.Text))
        //{
        //    tel = "";
        //}
        //else
        //{
        //    tel = this.Tel.Text;
        //}

        //if (string.IsNullOrEmpty(this.Tel2.Text))
        //{
        //    tel2 = "";
        //}
        //else
        //{
        //    tel2 = this.Tel2.Text;
        //}

        //if (string.IsNullOrEmpty(this.Country.Text))
        //{
        //    country = "";
        //}
        //else
        //{
        //    country = this.Country.Text;
        //}

        //if (string.IsNullOrEmpty(this.Province.Text))
        //{
        //    province = "";
        //}
        //else
        //{
        //    province = this.Province.Text;
        //}

        //if (string.IsNullOrEmpty(this.City.Text))
        //{
        //    city = "";
        //}
        //else
        //{
        //    city = this.City.Text;
        //}

        //if (string.IsNullOrEmpty(this.Addr.Text))
        //{
        //    addr = "";
        //}
        //else
        //{
        //    addr = this.Addr.Text;
        //}

        //if (string.IsNullOrEmpty(this.Email.Text))
        //{
        //    email = "";
        //}
        //else
        //{
        //    email = this.Email.Text;
        //}

        //if (string.IsNullOrEmpty(this.UserName.Text))
        //{
        //    userName = "";
        //}
        //else
        //{
        //    userName = this.UserName.Text;
        //}

        //if (string.IsNullOrEmpty(this.Passwd.Text))
        //{
        //    passwd = "";
        //}
        //else
        //{
        //    passwd = this.Passwd.Text;
        //}

        dal.UpdateClientById(classname, serial, client, tel, tel2, country, province, city, addr, email, userName, passwd, id);


        //if (a > 0)
        //{
        Response.Redirect("../DBTableManagement.aspx");
        Response.End();
        // }
        // else
        //{
        //        System.Threading.Thread.Sleep(2000);
        //        Response.Redirect("AddClient.aspx");
        //        Response.End();
        // }
        //}
    }