public void TestVendEmailUpdate() { //Test Our Read DataTable dt = cExcel.ReadExcelFile("Sheet1", Path.Combine(cExcel.GetHelperFilesDir(), "tblVendEmail.xlsx")); foreach (DataRow row in dt.Rows) // Loop over the rows. { string EmailAddr = "*****@*****.**"; int EmailID = Convert.ToInt32(row["EmailID"].ToString()); sp_VendEmail_DM data = new sp_VendEmail_DM(); data.EmailID = EmailID; data.EmailAddr = EmailAddr; sp_VendEmail_BLL vend = new sp_VendEmail_BLL(); vend.UpdateEmailContext(data); data = vend.ListEmails(EmailID); Assert.AreEqual(EmailAddr, data.EmailAddr, "EmailAddr Not Set As Expected"); } }