public static void GetEmailFile(string path, Page current)
{
ElevesHelper eh = new ElevesHelper();
System.Data.DataSet dsEmails = eh.EmailsLookup();
System.Data.DataTable dt = dsEmails.Tables[0];
String filepath = current.Server.MapPath(path);
System.IO.StreamWriter sw = new System.IO.StreamWriter(filepath, false);
int iColCount = dt.Columns.Count;
foreach (System.Data.DataRow dr in dt.Rows)
{
for (int i = 0; i < iColCount; i++)
{
if (!Convert.IsDBNull(dr[i]))
{
sw.Write(dr[i].ToString());
}
if (i < iColCount - 1)
{
sw.Write(",");
}
}
sw.Write(";");
sw.Write(sw.NewLine);
}
sw.Close();
}
