public void GetDataFromAccessDb()
{
string sql = @"SELECT * FROM T_EmailInfo";
DataSet ds = _accessDBConnection.GetDataFromDb(sql);
var dt = ds.Tables[0];
foreach (DataRow dtRow in dt.Rows)
{
string to = dtRow["To"].ToString();
string cc = dtRow["CC"].ToString();
string subject = dtRow["Subject"].ToString();
string body = dtRow["Body"].ToString();
insertIntoExcel(to, cc, subject, body);
}
_accessDBConnection.CloseDbConnection();
}
