Problem while exporting data from a datareader to excel sheet

[jas1582]

Hi fellas,
i am working on C# to get a page which generates results based on various filter critereon. I am populating the results in a datareader. Now i want to download this into an excel sheet. Can someone guide me as to how to go about it? Am using the following snippet which is throwing error.
Response.Clear();
Response.ContentType = "application/vnd.ms-excel";
string sep = "";

foreach (DataColumn dc in Dr2.Tables["actiontracker"].Columns)
{
Response.Write(sep + dc.ColumnName);
sep = "\t";
}
Response.Write("\n");
int i;
foreach (DataRow dr in Dr2.Tables["actiontracker"].Rows)
{
sep = "";
for (i = 0; i < Dr2.Tables["actiontracker"].Columns.Count; i++)
{
Response.Write(sep + dr[i].ToString());
sep = "\t";
}
Response.Write("\n");
}


Kindly throw some light on this or suggest some other snippet.