How to append DB values to a String

[srinivaskonijeti]

Hi , I just want a piece of code for appending a single column data base values of a table in a single string seperating by "," or "|".

[meeram395]

Could you explain a little bit more what exactly you want to do? Giving an example will be better

Success is the good fortune that comes from aspiration, desperation, perspiration and inspiration.

[Nouman Bhatti]

fetch your code in datareader from the table than loop throw the datareader and add the values in the string. steps to do that SqlConnection con = new SqlConnection("YOur connection string"); SqlCommand cmd = new SqlCommand(con,"Your query here"); con.Open(); DataReader dr = cmd.ExecuteNonQuery(); //confirm if this is the write function to call string strValues = string.Empty; while(dr.Read()) { strValues += dr[0].ToString(); } Note: There may be a bit of problem in this code.. i hope u can fix that.

[AlexeiXX3]

Ask SQL question on SQl forum Declare @result varchar(8000) select @result = Coalesce (@results + ',', '') + columnName from tableName where condition

Alexei Rodriguez