static void FillNewsletterEmails() { DataTable dt = new DataTable(); DBConnection obj = new DBConnection(); try { dt = VADBCommander.ContactEmailList(); //fill new table with unioned table foreach (DataRow row in dt.Rows) { VADBCommander.NewsLetterEmailShortAdd(row["contactemail"].ToString(), row["contactName"].ToString()); } } catch (Exception ex) { throw ex; } finally { con.Close(); } }