Comma Separated BulletedList

Ok I'm pulling data in from an SQL database. The data is separated with commas and I would like to display each item as a bullet in a BulletedList. Is this doable? If so how? Here's what I have, I know it's not much but I can't find much info on doing this so I'm stuck.

<asp:BulletedList ID="BulletedList1" runat="server"
DataSourceID="SqlDataSource2" DataTextField="Options">
</asp:BulletedList>

Re: Comma Separated BulletedList

Yes ,

After getting data from DB , you need to create a datasouce for BulletedList . this source should have a collection , need to split data by comma .

Re: Comma Separated BulletedList

Ok I'm pretty new to ASP so I'm not sure I follow. The data already has the commas in it so I need to do something else with it? When you say split data by comma what exactly do you mean and how do I go about doing that?

Re: Comma Separated BulletedList

You have to assign DataValueField as well. Try this:

<asp:BulletedList ID="BulletedList1" runat="server"
DataSourceID="SqlDataSource2"
DataTextField="Options"
DataValueField="OptionID"
DisplayMode="LinkButton">
</asp:BulletedList>


<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConnectionString="<%$ YourConnectionString %>"
SelectCommand="SELECT [OptionID], [Options] FROM [Option]">
</asp:SqlDataSource>

http://www.ezineasp.net/post/Using-ASP-Net-BulletedList-Control-with-SQL-DataSource.aspx

Re: Comma Separated BulletedList

I can connect to the SQLDataSource without any troubles. The problem is I want to make my list add a bullet at every comma. This is how my data currently displays:

Item 1, Item 2, Item 3

I would like it to separate each item using the commas though so it displays like this:

Item 1
Item 2
Item 3

Does that make more sense?

Re: Comma Separated BulletedList

Yes, just use my previous code.

do not use the comma separated list. Just use the sqldatasouce as datasourceId.

use sqldatasource to get data from database and bind that to bulletlist control.

Re: Comma Separated BulletedList

But the items are stored as one string separated by commas. The items are stored as "Item 1, Item 2, Item 3." When I use the previous code it just displays it all as one bullet.

Re: Comma Separated BulletedList

ok, got it. So you have stored that way on database, right ?

Re: Comma Separated BulletedList

Yeah that's correct

Re: Comma Separated BulletedList

split that list into an array and then simple lloop to grab and assign a bullet in code behind.

Re: Comma Separated BulletedList

Ok, this is all new to me. I figured if I could get my data to a String though I could manipulate it from there and get the results I wanted. So I've been trying to save my DataSet to a lable but it just says "System.Data.DataSet" when I run my code. Here's how I'm doing it:

lblTest.Text = GetAllOptions().ToString()

Public Shared Function GetAllOptions() As DataSet

Dim con As New SqlConnection(ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString)

Dim sel As String = "SELECT [Options] FROM [Vehicles] WHERE ([VIN] = VIN)"

Dim da As New SqlDataAdapter(sel, con)

Dim ds As New DataSet

da.Fill(ds, "Vehicles")

Return ds

End Function

So what am I don't wrong? Or what do I need to do different? Is there another way I could make this work? I mean could I just replace the commas in the database with <br /> or something? I don't care how it works, I just want it to work.

Thanks for all your help on this BTW

Re: Comma Separated BulletedList

to get data and display in label, see my post here:

http://forums.asp.net/t/1749714.aspx/1

when you read the data from database, you can add bullet in code behind (like i said in my previous post).

If you want to change the data format in SQL:

If you change the comma by break tag, it just display into nexxt line but no bullet.

To get bullet list, you have to have list item tags and store into database:

<ul><li>First item<li>Second item<li>Third item</ul>

http://www2.gol.com/users/billp/articlehtml/bullet.html

Re: Comma Separated BulletedList

Thanks, that worked.