Bind ListBox

[Andre]

Hi,

I try to bind my dataset to a listbox, but i can't find a way to make it
work. I'm lost ;o)

Dim ConnStr As String = "myconnectionst ring..."
Dim SQL As String = "SELECT Town from Info group by Town;"
Dim myConnection As New SqlConnection(C onnStr)
Dim myCommand As New SqlCommand(SQL, myConnection)
Dim MyAdapter As New SqlDataAdapter
Dim mydataset As New DataSet

MyAdapter.Selec tCommand = myCommand
myConnection.Op en()
MyAdapter.Fill( mydataset) --------- or MyAdapter.Fill( mydataset, "Town")

--- this line is for a test, don't know if i need to use it -------
Dim LbView As New DataView(mydata set.Tables("Tow n"))

LB1.DataSource = mydataset
LB1.DataBind()
myConnection.Cl ose()

On the LB1.Datasource line :
if i use "= mydataset" i receive only system.data.dat arowview for all the
item in my listbox.
if i use "= mydataset.LbVie w .. same thing
if i use "= mydataset.conta iner ... my listbox is empty, or fill with empty
string

Did someone have any idea what is wrong with my code ?

Thank you

[Ken Tucker [MVP]]

Hi,

LB1.DataSource = Lbview or LB1.Datasource = mydataset.table s("Town")
LB1.Displaymemb er = "Town"

Ken
----------------
"Andre" <lo*****@cablev ision.qc.ca> wrote in message
news:%2******** ********@TK2MSF TNGP11.phx.gbl. ..

Hi,

I try to bind my dataset to a listbox, but i can't find a way to make
it
work. I'm lost ;o)

Dim ConnStr As String = "myconnectionst ring..."
Dim SQL As String = "SELECT Town from Info group by Town;"
Dim myConnection As New SqlConnection(C onnStr)
Dim myCommand As New SqlCommand(SQL, myConnection)
Dim MyAdapter As New SqlDataAdapter
Dim mydataset As New DataSet

MyAdapter.Selec tCommand = myCommand
myConnection.Op en()
MyAdapter.Fill( mydataset) --------- or MyAdapter.Fill( mydataset, "Town")

--- this line is for a test, don't know if i need to use it -------
Dim LbView As New DataView(mydata set.Tables("Tow n"))

LB1.DataSource = mydataset
LB1.DataBind()
myConnection.Cl ose()

On the LB1.Datasource line :
if i use "= mydataset" i receive only system.data.dat arowview for all the
item in my listbox.
if i use "= mydataset.LbVie w .. same thing
if i use "= mydataset.conta iner ... my listbox is empty, or fill with
empty
string

Did someone have any idea what is wrong with my code ?

Thank you