protected void btnThem_Click(object sender, EventArgs e)
        {
            data = new dtKhachHang();
            DataTable db = data.DanhSachKhachHang_Import_Temp();

            if (db.Rows.Count != 0)
            {
                foreach (DataRow dr in db.Rows)
                {
                    string IDNhomKhachHang = dr["IDNhomKhachHang"].ToString();
                    string MaKhachHang     = dr["MaKhachHang"].ToString();
                    string TenKhachHang    = dr["TenKhachHang"].ToString();
                    string NgaySinh        = dr["NgaySinh"].ToString();
                    string DiaChi          = dr["DiaChi"].ToString();
                    string CMND            = dr["CMND"].ToString();
                    string DienThoai       = dr["DienThoai"].ToString();
                    string DiemTichLuy     = dr["DiemTichLuy"].ToString();

                    string GhiChu = dr["GhiChu"].ToString();

                    if (data.KiemTraSDTKhachHang(DienThoai) == 0)
                    {
                        data.ThemKhachHang(Int32.Parse(IDNhomKhachHang), MaKhachHang, TenKhachHang, DateTime.Parse(NgaySinh), CMND, DiaChi, DienThoai, GhiChu);
                        LoadGrid();
                    }
                }

                Response.Redirect("KhachHang.aspx");
            }
            else
            {
                Response.Write("<script language='JavaScript'> alert('Dữ liệu trống? Vui lòng kiểm tra lại.'); </script>");
            }
        }
 private void LoadGrid()
 {
     data = new dtKhachHang();
     gridKhachHang_Temp.DataSource = data.DanhSachKhachHang_Import_Temp();
     gridKhachHang_Temp.DataBind();
 }