Listbox on windows form

[venerable bede]

I am being driven insane by this stupid little problem.
I use the following code to bind a list of tables from my database to a listbox control on a windows form :

 
Dim strConnectionString
        Dim dtTables As New DataTable
        strConnectionString = "data source=server;database=dbname;user id=doggy;password=poopoo"
        'Create connection object
        Dim Connect As New SqlConnection(strConnectionString)
        Dim strSQL As String
        strSQL = "Select Name from dbo.sysobjects "
        strSQL += "where OBJECTPROPERTY(id, N'IsView') = 1 "
        strSQL += "OR OBJECTPROPERTY(id, N'IsUSERTABLE') = 1 "
        Dim daSQL = New SqlDataAdapter(strSQL, Connect)
        daSQL.fill(dtTables)
        lstTables.DataSource = dtTables
        lstTables.DisplayMember = "Name"

I then use the following code (In the selected index changed event from the listbox) to display the chosen table name in a label control :

lblTable.Text = lstTables.SelectedItem

I keep getting the error :
An unhandled exception of type 'System.InvalidCastException' occurred in microsoft.visualbasic.dll

AAAAArrrrgggghhhh....whats wrong here. ASP.net is so easy.

[kleinma]

is it a listbox or listview? cause you called it both

also put on option strict and your error may become more apparent

[venerable bede]

Its a listbox.

Where do I call it a listview ?

[kleinma]

Its a listbox.

Where do I call it a listview ?

the first line of ur post

I use the following code to bind a list of tables from my database to a listview control on a windows form

[kleinma]

anyway, I am not a big fan of data binding, but try something like this, since listboxes hold objects and not strings like VB6

lblTable.Text = lstTables.SelectedItem.ToString

[venerable bede]

Apologies

[kleinma]

hahaha

well did it work?

[venerable bede]

Nope



GGGGrrrrrrrrrrrrrrrrrrrr

[kleinma]

ok so the listbox populates correctly though??? its just the line of code with the label you are having trouble with?

[venerable bede]

It populates the Listbox with all my tables but when I click on an entry I get :

An unhandled exception of type 'System.InvalidCastException' occurred in microsoft.visualbasic.dll

Additional information: Cast from type 'DataRowView' to type 'String' is not valid.

This is childsplay. I am ashamed of myself.

[kleinma]

ok here it is

lblTable.Text = lstTables.GetItemText(lstTables.SelectedItem)

[venerable bede]

I love U Kleinma.

May Santa shower you with gifts.
A new high spec PC, IPAQ, He man action figures and Skull mountain and a Jag....with some naked nuns and a midget thrown in.

You can have Bodwad for a few hours gratification as well.


I still feel a right pensi though.

[kleinma]

I want castle grayskull please, mine was demolished as a child in a freak accident when somehow it fell (was thrown) off my roof