protected void btnUpload_Click(object sender, EventArgs e) { var extension = Path.GetExtension(fuData.FileName); //verify file var verifyResult = VerifyFile(extension); if (verifyResult) { //get table data var dt = new DataTable(); using (Stream stream = fuData.PostedFile.InputStream) dt = ImportExcel(stream, extension, ""); if (dt.Rows.Count == 0) { lbMsg.Text = "Data is empty"; } else { using (TransactionScope txnScope = new TransactionScope()) { _dBHelper.DeleteAllBankCardList(); _dBHelper.InsertFullBankCardList(dt); txnScope.Complete(); } lbMsg.Text = "Upload successfully"; BankCardHelper.BankCardList = GeneralUtility.ConvertDataTableToList <BankCard>(_dBHelper.GetBankCardList(0, 0, true)); } } }