data is not coming in table format on sqldatareader

Question

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 { string tmpColumnName = oDataReader.GetName(i); columnNames.Add(tmpColumnName); } builder.Append( string .Join( "," , columnNames.ToArray())).Append( "
" ); List string > currentRow = new List string >(); while (oDataReader.Read()) { ////base.WriteLog(oDataReader.FieldCount + "fieldcount"); for ( int i = 0; i { object item = oDataReader[i]; currentRow.Add(item.ToString()); } } //builder.Append(string.Join("
", rows.ToArray())).Append("
"); rows.Add( string .Join( "," , currentRow.ToArray())); builder.Append( string .Join( "," , rows.ToArray())).Append( "
" ); 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:

Manoj Maharana · Answer

protected void Write_CSV_From_Recordset2(SqlDataReader oDataReader) { string strCSV = string .Empty; for ( int i = 0; i { string tmpColumnName = oDataReader.GetName(i); strCSV += tmpColumnName + ',' ; } strCSV += "
" ; while (oDataReader.Read()) { for ( int i = 0; i { object item = oDataReader[i]; strCSV += item.ToString().Replace( "," , ";" ) + ',' ; } strCSV += "
" ; } //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 Sontakke · Answer

You just changed the playing field.

Nitin Sontakke · Answer

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());

Nitin Sontakke · Answer

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( "
" );