write multiple results into a text file

Question

I have a stored procedure  ( test 1) that returns multiple select results and I would like to write the output ( both header and rows) into a text file using C#
For example, the output from SP looks like below (the sp has multiple select statements)
OrderID
1001
OrderItem   OrderPlace
Book1            CA
Book2            NY
Book3            FL
OrderDate
01/02/2014
Orderby
James
Mike
And I would like to create a text file that includes above result from a sp using C#. How can I do this?

Answer

Hi J C,
Using file stream and stream writer class you can get your thing you want
For Example:
suppose your results are in a table named DT, use loop like(foreach or for) to gets row values and write that values into file using stream writer. See below code
this.FS = new FileStream(txtFilename.Text.Trim(), FileMode.Truncate, FileAccess.ReadWrite);             StreamWriter SW = new StreamWriter(this.FS);             DataTable DT = new DataTable();             foreach (DataRow DR in DT.Rows)             {                 SW.Write(DR["OrderID"].ToString());                 SW.Write(DR["OrderItem"].ToString() + "	" + DR["OrderPlace"].ToString());                 SW.Write("OrderDate");                 SW.Write(DR["OrderDate"].ToString());                 SW.Write("Orderby");                 SW.Write(DR["Orderby"].ToString());             }             SW.Flush();             FS.Flush();             FS.Dispose();             FS.Close();
kindly mark as answer, if it solves your problem