data is not coming in table format on sqldatareader

Manoj Maharana

Here is the code:

protected void Write_CSV_From_Recordset2(SqlDataReader oDataReader)
{
StringBuilder builder = new StringBuilder();
List<string> columnNames = new List<string>();
List<string> rows = new List<string>();
for (int i = 0; i < oDataReader.FieldCount; i++)
{
string tmpColumnName = oDataReader.GetName(i);
columnNames.Add(tmpColumnName);
}
builder.Append(string.Join(",", columnNames.ToArray())).Append("\n");
List<string> currentRow = new List<string>();
while (oDataReader.Read())
{
////base.WriteLog(oDataReader.FieldCount + "fieldcount");
for (int i = 0; i < oDataReader.FieldCount; i++)
{
object item = oDataReader[i];
currentRow.Add(item.ToString());
}
}
//builder.Append(string.Join("\n", rows.ToArray())).Append("\n");
rows.Add(string.Join(",", currentRow.ToArray()));
builder.Append(string.Join(",", rows.ToArray())).Append("\n");
Response.Clear();
Response.ContentType = "text/csv";
Response.AddHeader("Content-Disposition", "attachment;filename=pretestscore.csv");
Response.Write(builder.ToString());
Response.End();
}

The problem is that :

while output is coming problem that means while (oDataReader.Read()) function the value are coming just like 281063,70,7091,85,TEST,200,test,NULL. how to get actually data from the table? Where is the wrong in my code? any suggestion?

Here is the table structure:

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke9y ago
You just changed the playing field.
0

Manoj Maharana9y ago


protected void Write_CSV_From_Recordset2(SqlDataReader oDataReader)  
    {  
        string strCSV = string.Empty;  
  
        for (int i = 0; i < oDataReader.FieldCount; i++)  
        {  
            string tmpColumnName = oDataReader.GetName(i);  
  
            strCSV += tmpColumnName + ',';  
        }  
  
        strCSV += "\r\n";  
  
  
  
        while (oDataReader.Read())  
        {  
  
  
            for (int i = 0; i < oDataReader.FieldCount; i++)  
            {  
                object item = oDataReader[i];  
  
                strCSV += item.ToString().Replace(",", ";") + ',';  
  
            }  
  
  
            strCSV += "\r\n";  
  
        }  
  
  
        //Download the CSV file.  
        Response.Clear();  
        Response.Buffer = true;  
        Response.AddHeader("content-disposition", "attachment;filename=pretestscore.csv");  
        Response.Charset = "";  
        Response.ContentType = "application/text";  
        Response.Output.Write(strCSV);  
        Response.Flush();  
        Response.End();  
  
  
    }  
This is the solution.

Nitin Sontakke9y ago
In addition, how is NULL from data reader is being treated by your code. I suggest, you modify the code as follows:

currentRow.Add(oDataReader.IsDBNull(i) ? "" : item.ToString());
0
Nitin Sontakke9y ago
I think that the following two lines should be inside the while loop. Why are they not in the while loop?
rows.Add(string.Join(",", currentRow.ToArray()));
builder.Append(string.Join(",", rows.ToArray())).Append("\n");
0