DataSet ds = new DataSet();
using (SqlConnection conn = new SqlConnection("Connection String"))
{
SqlCommand sqlComm = new SqlCommand("dbo.Test", conn);
sqlComm.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(sqlComm);
da.Fill(ds);
}
StreamWriter sw = null;
StringBuilder sb = new StringBuilder();
foreach (DataTable dt in ds.Tables)
{
sw = new StreamWriter(string.Format(@"C:\Users\GP Test Folder\Export" + datetime.ToString("dd-MM-yyyy_hh-mm-ss") + ".csv", dt.TableName));
for (int i = 0; i < dt.Rows.Count; i++)
{
sb.Clear();
for (int j = 0; j < dt.Columns.Count; j++)
{
sb.Append(dt.Rows[i][j]);
if (j == (dt.Columns.Count - 1)) sb.Append(",");
}
sw.WriteLine(sb.ToString());
}
sw.Close();
}
Also you haven't include table name in your file name.
string.Format(@"C:\Users\GP Test Folder\Export{0}" + datetime.ToString("dd-MM-yyyy_hh-mm-ss") + ".csv", dt.TableName)