Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: ASP.NET
Hi,
 
I want to populate a listbox from databse while values in databse are comma separated.
I have values in the table columns like this "fever, cough".
 
Please guide me as to how I can populate these items in listbox?
I intend to populate in such a way that each item should appear in separete row in the listbox.
 
Thanks in Advance
Posted 11-Jan-11 21:49pm
Edited 11-Jan-11 23:02pm
Dalek Dave432.4K
v3
Comments
Dalek Dave at 12-Jan-11 5:02am
   
Edited for Readability.

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

You can split the comma seperated values into a string array and you can assign the array as a DataSource to the ListBox.
 
For example:
 
string commaSeperatedData = "data1,data2,data3";
ListBox1.DataSource = commaSeperatedData.Split(',');
ListBox1.DataBind();
  Permalink  
Comments
Dalek Dave at 12-Jan-11 5:02am
   
Good Answer.
Espen Harlinn at 12-Jan-11 5:22am
   
5+ Nice and easy, no fuss

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 756
1 OriginalGriff 345
2 Magic Wonder 131
3 Kishore Pogaru 130
4 Fredrik Bornander 130
0 OriginalGriff 5,705
1 Sergey Alexandrovich Kryukov 4,763
2 CPallini 4,570
3 George Jonsson 3,142
4 Gihan Liyanage 2,450


Advertise | Privacy | Mobile
Web03 | 2.8.140916.1 | Last Updated 11 Feb 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100