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(); }
}
