SqlDataReader and Comma Seperated Values

[spons]

Is there an easy way to Retrive Data With A DataReader and Convert it into Comma Seperated Values? I remember reading about something like this before and now I need to use it.

 

[cappmgr]

Could try this,
string sep = ", ";
StringBuilder sb = new StringBuilder();
while (dr.Read())
{
for (int i = 0; i < dr.FieldCount; ++i)
{
sb = sb.Append(dr.GetValue(i));
sb = sb.Append(sep);
}
}
sb.Remove(sb.Length - 2,2); //remove the trailing comma
string str = sb.ToString();
Marty

 

[obislavu]

Another solution is for each successfull read that will return the columns with their values and types,
use string.Join() to concatenate the columns values as strings using a given separator.

myReader =new SqlDataReader();
string sep = ";"
Array myTargetArray=Array.CreateInstance( typeof(String), myReader.FieldCount );
for (int i=0;i<myReader.FiledCount;i++)
  myTargetArray.Add(myReader[i],i);
string sCommasep = String.Join(sep, myTargetArray);

-obislavu