listbox

[ngchaitra]

Hi,

How to read a string which has comma from a table and to bind to listbox. I want display each item after comma as a different list item. I know i have to use split function but facing problem while implementing.

[prabunewindia]

hi friend,
u can split string by any char as ur wish

ex:
string items="one,two,three";
string[] itemArray=items.Split(',');

now u can get
itemArray[0]=one like this

Try it out
Prabu

Hi,

How to read a string which has comma from a table and to bind to listbox. I want display each item after comma as a different list item. I know i have to use split function but facing problem while implementing.

[ngchaitra]

hi friend,
u can split string by any char as ur wish

ex:
string items="one,two,three";
string[] itemArray=items.Split(',');

now u can get
itemArray[0]=one like this

Try it out
Prabu

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 the following code,

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

[prabunewindia]

hi friend,

use foreach loop to get strings in string array
inside loop additem
Prabu

But, How do I bind that to a listbox. I have the following code,

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

[prabunewindia]

hi friend,
try with this code

string aaa = "";
string[] itemArray=aaa.Split(',');
foreach(string item in itemArray)
{
listbox.Items.Add(item);
}

Prabu

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 the following code,

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

[ngchaitra]

hi friend,
try with this code

string aaa = "";
string[] itemArray=aaa.Split(',');
foreach(string item in itemArray)
{
listbox.Items.Add(item);
}

Prabu

Hi prabhu, I used the following code as u said, but i am seeing select swinstalled from a_desktops where assetcode= D067 in the listbox :(

Sub listsplit()
Dim str As String = "select swinstalled from a_desktops where assetcode='" & TextBox1.Text & "'"
Dim Cmd As New SqlCommand(str, dbconn)
Dim objReader As SqlDataReader
Dim delimStr As String = ","
If dbconn.State = ConnectionState.Closed Then
dbconn.Open()
End If
Dim itemArray() As String = str.Split(","c)
Dim item As String
objReader = Cmd.ExecuteReader(CommandBehavior.CloseConnection)
For Each item In itemArray
lstselectedemployees.Items.Add(item)
Next
End Sub

[prabunewindia]

hi friend,
i am not getting u da
here u splited the query(str="select swinstalled from a_desktops where assetcode='" & TextBox1.Text & "'")

but u should split the string, what u r getting from database know?
so from reader get it to the string and then do the for loop process

i not well with vb.net
but i think u did mistake in that
For Each item In itemArray ****

For Each string item In itemArray (i think this is correct, not sure)
u give the output u r getting, then it is easy to find sol for me
also error if u get so
Prabu

Hi prabhu, I used the following code as u said, but i am seeing select swinstalled from a_desktops where assetcode= D067 in the listbox :(

Sub listsplit()
Dim str As String = "select swinstalled from a_desktops where assetcode='" & TextBox1.Text & "'"
Dim Cmd As New SqlCommand(str, dbconn)
Dim objReader As SqlDataReader
Dim delimStr As String = ","
If dbconn.State = ConnectionState.Closed Then
dbconn.Open()
End If
Dim itemArray() As String = str.Split(","c)
Dim item As String
objReader = Cmd.ExecuteReader(CommandBehavior.CloseConnection)
For Each item In itemArray
lstselectedemployees.Items.Add(item)
Next
End Sub