asked on 11/14/2014

Create comma separated list without last comma

I have a combobox with multiple selections and want to create a comma separated list form the selectedvalues.

I have this

Dim sbSp As New StringBuilder()
Dim collectionSp As IList(Of RadComboBoxItem) = ddlUsers.CheckedItems
For Each item As RadComboBoxItem In collectionSp
sbSp.Append(item.Value + ",")
Next

RoomUsers = sbSp.ToString

What this gives me is the correct list but there is always a comma at the end.
What do I need to change to remove the comma.

Andy

Microsoft SQL Server

Last Comment

Andy Green

11/17/2014

Jim Horn

11/14/2014

I've don this in SQL Server and Access VBA before, and essentially you get the length of the string, then all left characters of the length minus one. Something like..

 RoomUsers = LEFT(sbSp.ToString, LEN(sbSp.ToString) - 1 )

Open in new window

ASKER CERTIFIED SOLUTION

Kyle Abrahams, PMP

11/14/2014

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

Andy Green

11/14/2014

ASKER

Thanks Guys, yes agree I want to do this before I send it off to the server, is there a test that can be done so its not added in the first place rather than add the comma them remove it?

Andy

Jim Horn

11/14/2014

Test, well yes, but that would likely be much more code then just looping and adding the item.value + comma to a string, then after the loop slicing off the last comma at the end.

Andy Green

11/17/2014

ASKER

Thanks, works fine.

Andy