How to read comma seperated value in the listbox

[ngchaitra]

Hi,
I have a registration form where i am using a listbox where we can select multiple values.I am storing these values concatenating with commas(for eg. A,B,C).Now i have to update this registration form, so i have to retrieve these values.
I have the idea that first i have to retrieve that field from database and split the commas and then i have to write the code in the front end to display the values.
But in real time i m unable to display in front end.
Can anyone help me.

have the following code to bind the data from a table to listbox.Sub ListLoad()
' ||||| DECLARE VARIABLES |||||
Dim mystring As String = "select swinstalled from a_desktops where assetcode='" & TextBox1.Text & "'"
Dim Cmd As New SqlCommand(mystring, dbconn)
Dim objReader As SqlDataReader
Dim objReader As SqlDataReader
Dim delimStr As String = ","

Dim delimiter As Char() = delimStr.ToCharArray()
Dim s As String
For Each s In strProducts.Split(delimiter)
Response.Write((s.ToString() + "<br>"))
Dim Cmd As New SqlCommand(mystring, dbconn)
Next
Try
If dbconn.State = ConnectionState.Closed Then
dbconn.Open()
End If
objReader = Cmd.ExecuteReader(CommandBehavior.CloseConnection)
lstselectedemployees.Items.Clear()
lstselectedemployees.DataTextField = "Swinstalled"
lstselectedemployees.DataSource = objReader
lstselectedemployees.DataBind()
objReader.Close()
Catch ex As Exception
MsgBox("Error Connecting to Database!", MsgBoxStyle.Critical)
End Try
Thanks and regards

[nateraaaa]

Hi,
I have a registration form where i am using a listbox where we can select multiple values.I am storing these values concatenating with commas(for eg. A,B,C).Now i have to update this registration form, so i have to retrieve these values.
I have the idea that first i have to retrieve that field from database and split the commas and then i have to write the code in the front end to display the values.
But in real time i m unable to display in front end.
Can anyone help me.

have the following code to bind the data from a table to listbox.Sub ListLoad()
' ||||| DECLARE VARIABLES |||||
Dim mystring As String = "select swinstalled from a_desktops where assetcode='" & TextBox1.Text & "'"
Dim Cmd As New SqlCommand(mystring, dbconn)
Dim objReader As SqlDataReader
Dim objReader As SqlDataReader
Dim delimStr As String = ","

Dim delimiter As Char() = delimStr.ToCharArray()
Dim s As String
For Each s In strProducts.Split(delimiter)
Response.Write((s.ToString() + "<br>"))
Dim Cmd As New SqlCommand(mystring, dbconn)
Next
Try
If dbconn.State = ConnectionState.Closed Then
dbconn.Open()
End If
objReader = Cmd.ExecuteReader(CommandBehavior.CloseConnection)
lstselectedemployees.Items.Clear()
lstselectedemployees.DataTextField = "Swinstalled"
lstselectedemployees.DataSource = objReader
lstselectedemployees.DataBind()
objReader.Close()
Catch ex As Exception
MsgBox("Error Connecting to Database!", MsgBoxStyle.Critical)
End Try
Thanks and regards

Why do you have 2 datareaders initialized with the same name? Also will any of your data in the listbox contain commas? If so you may want to make your delimiter a different character, such as a | or a _ . Try removing one of the objReader declarations. Also check the contents of your listbox using the debugger to make sure that your listbox is being populated when you call .DataBind().

Nathan

[ngchaitra]

Why do you have 2 datareaders initialized with the same name? Also will any of your data in the listbox contain commas? If so you may want to make your delimiter a different character, such as a | or a _ . Try removing one of the objReader declarations. Also check the contents of your listbox using the debugger to make sure that your listbox is being populated when you call .DataBind().

Nathan

By mistake i have given 2 datareaders. But still i know something is missing in my code. I am not binding split function with listbox(lstselectedemployees). I dont know how to do that.

[ngchaitra]

By mistake i have given 2 datareaders. But still i know something is missing in my code. I am not binding split function with listbox(lstselectedemployees). I dont know how to do that.

But, How do I bind that to a listbox.

I am working in asp.net 2.0 and using vb script.

Let us assume i have table "A_desktops" with columns assetcode and swinstalled.

Assecode Swinstalled
D001 sql,vb,Sap
D002 vs 2005, sql 2005
D003 Microsoft SQL Server 2000 Microsoft Office 97, Std Edition SAP

When i bind the data based on asset code say D003 to listbox it bind as Microsoft SQL Server 2000 Microsoft Office 97, Std Edition SAP But i want them to display different listitems after comma.



I have tried the following code also, but something is missing, some connectivity may be but i could not figure it out

Sub ListLoad()
' ||||| DECLARE VARIABLES |||||
Dim strProducts As String = "select swinstalled from a_desktops where assetcode='" & TextBox1.Text & "'"
Dim Cmd As New SqlCommand(strProducts, dbconn)
Dim objReader As SqlDataReader

Dim itemArray() As String = strProducts.Split(",")


Try
If dbconn.State = ConnectionState.Closed Then
dbconn.Open()
End If
objReader = Cmd.ExecuteReader(CommandBehavior.CloseConnection)
lstselectedemployees.Items.Clear()
lstselectedemployees.DataTextField = "Swinstalled"
lstselectedemployees.DataSource = objReader
lstselectedemployees.DataBind()
objReader.Close()
Catch ex As Exception
MsgBox(ex.ToString)
End Try[/quote]