Name concatenating from table

Question

Hi, I want to display co visitor name details means not a single name for mutiple name should disply in print page ram,shyam,papa . for sigle ram display the code is through join it's working fine. if i have mutiple names then how can i show in the asp.net c# code lblcovisitornames.Text = dt_rec.Rows[0]["name"].ToString();

Sreekanth Reddy · Answer

Hi Debasis, string covisitors = string.Empty; for(int i=0;i { covisitors = covisitors +dt_rec.Rows[i]["name"].ToString()+","; } //To remove last appended comma. covisitors = covisitors.Remove(covisitors.Length-1); lblcovisitornames.Text = covisitors; If it helps, Mark as answer. Thank you.

Debasis Mohapatra · Answer

Thank You Jignesh.

Jignesh Kumar · Answer

Hi Debasis, You can change your fetching column as below and and bring all co visitor records by comma seperated, Declare @ListName varchar ( max ) SELECT @ListName = COALESCE (@ListName+ ',' , ' ' ) + Name FROM Result select @ListName If your issue resolved then please mark answer

Debasis Mohapatra · Answer

string covisitors = string.Empty; for (int i = 0; i { covisitors = covisitors+dt_rec.Rows[i]["name"].ToString()+","; } covisitors = covisitors.Remove(covisitors.Length - 1); lblcovisitornames.Text = covisitors;

Sreekanth Reddy · Answer

Hi Debasis, Sorry,I had modified it now. Please check once. If it helps. Mark as answer. Thank you.

Debasis Mohapatra · Answer

Dear Srikant, Thank you for your help but comma is not comming, means debasis,pralya the covisitors name will be display like debasis,pralya but in your code it's comming like debasispralya. Please check the code agian.