Concatenate a datareader list into a string

[Tom]

Hi

I want to retrieve database data and concatenate them to a string. Here is my code

[code

string sql = "Select phone From users where userid=1 or userid=2 or userid=3 or userid=4

SqlDataReader dr = null

dr = SqlHelper.ExecuteReader(DBConnection.ConnString, CommandType.Text, sql)

ArrayList list = new ArrayList(0)
d

list.Add(dr["phone"].ToString()); //runtime error her
} while (dr.NextResult())

string[] array = (string[])list.ToArray(typeof(string));
string result = String.Join(", ", array)

[/code

I want to concatenate the phone number in DB to a string like
result = "123456,234567,345678,456789

How should I modify the code

Thanks

[Marcin Grzêbski]

Hi Tom,

Hi,

I want to retrieve database data and concatenate them to a string. Here is my code:

 string sql = "Select phone From users where userid=1 or userid=2 or userid=3 or userid=4;

 SqlDataReader dr = null;

 dr = SqlHelper.ExecuteReader(DBConnection.ConnString, CommandType.Text, sql);

 ArrayList list = new ArrayList(0);

 

object phoneObj;

 

//>     do

 

while( dr.NextResult() )

     {

//         list.Add(dr["phone"].ToString()); //runtime error here

 

phoneObj=dr["phone"];

 

// write phones that aren't empty

if( phoneObj!=DBNull.Value ) {

list.Add(phoneObj.ToString().Trim());

// Trim() only if your numbers should not

// have empty spaces

}

 

//>     } while (dr.NextResult());

 

}

 string[] array = (string[])list.ToArray(typeof(string));

//> string result = String.Join(", ", array);

 

string result = String.Join(",", array);

// lifting change