Name concatenating from table

Debasis Mohapatra

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

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sreekanth Reddy7y ago
Accepted answer
Hi Debasis,
string covisitors = string.Empty;
for(int i=0;i < dt_rec.Rows.Count; 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 Mohapatra7y ago
Thank You Jignesh.
Jignesh Kumar7y ago
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 Mohapatra7y ago
string covisitors = string.Empty;
for (int i = 0; i < dt_rec.Rows.Count; i++)
{
covisitors = covisitors+dt_rec.Rows[i]["name"].ToString()+",";
}
covisitors = covisitors.Remove(covisitors.Length - 1);
lblcovisitornames.Text = covisitors;
Sreekanth Reddy7y ago
Hi Debasis,
Sorry,I had modified it now. Please check once.
If it helps. Mark as answer.
Thank you.
Debasis Mohapatra7y ago
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.