Separate data by comma

Hi,

I have a datalist on my page and I want to access it with code to insert its values, seperated by commas.

I have looked around and it seems that I need to do something to the select statement of the other control first - I have got:

SELECT [Usersname]= COALESCE (Usersname + ' , ' , ' ')
FROM [Transactions] WHERE ([Itemid] = @dotnet.itags.org.Itemid)

Does that look right?

And when I have selected these values, how do I insert them in the same format (separated by commas) ?:

DataView dv = SqlDataSource2.Select(DataSourceSelectArguments.Empty) as DataView;
string receivername = dv[0]["receivername"].ToString();
command.Parameters.AddWithValue("@dotnet.itags.org.recievername", receivername);

Would that still work?

Thanks,

Jon

pls help!

If I m not wrong, I understand from your question that you need to enter multiple rows in database.

You can refer

http://zirmandli.wordpress.com/2007/09/22/data-access-application-block-gets-batch-update-functionality-in-enterprise-library-30/

I hope this will help u....

Hi,

No, I didnt explain well enough. I will repost.

Thanks anyway

Jon