How to display the names of my SQL Server tables in a listbox using vb.net? [duplicate]

Question

I want to show the names of the tables I have in my SQL Server database in a listbox using vb.net.

I tried this but it's not working:

 connetionString = "Data Source=ABDELOUAHED;Initial Catalog=table_creances;integrated security=true"
 connection = New SqlConnection(connetionString)

 sql = "select * from table_creances"

 Try
        connection.Open()
        adapter = New SqlDataAdapter(sql, connection)
        ds.Clear()
        adapter.Fill(ds)
        connection.Close()
        ListBox1.DataSource = ds.Tables(0)
    Catch ex As Exception
        MsgBox(ex.ToString)
    End Try

table_creances is the name of my database.

Any help is very appreciated.

SELECT name FROM sys.tables

Trevor
– Trevor

2016-03-22 15:59:57 +00:00
Commented Mar 22, 2016 at 15:59 — Trevor
– Trevor, Commented Mar 22, 2016 at 15:59

Adam Silenko · Accepted Answer · 2016-03-22 19:14:26Z

1

Try use system view sys.objects

try this code:

Using connection As New SqlConnection(connetionString)
    connection.Open()
    adapter = New SqlDataAdapter("SELECT name FROM sys.tables", connection)
    Using ds = new DataSet()
        adapter.Fill(ds)
        with ListBox1
            .DataSource = ds.Tables(0)
            .DisplayMember = "name"
            .ValueMember = "name"
        end with
    End Using
End Using

edited Mar 22, 2016 at 19:14

answered Mar 22, 2016 at 16:05

Adam Silenko

3,1062 gold badges19 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

marc_s Over a year ago

Or better yet: for tables use sys.tables

Abdelouahed EL HARIRI Over a year ago

i get system.data.grid.rows on my list box

Adam Silenko Over a year ago

did you set sql = "SELECT name FROM sys.tables" ?

Abdelouahed EL HARIRI Over a year ago

thank you very muck it's working perfectly :)

Adam Silenko Over a year ago

but the question should be: how to set query as DataSource of LsListBox using vb

Tonny · Accepted Answer · 2016-03-22 16:01:31Z

0

Try this as your sql

sql = "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES"

answered Mar 22, 2016 at 16:01

Tonny

1099 bronze badges

3 Comments

Abdelouahed EL HARIRI Over a year ago

i get system.data.grid.rows on my list box

Tonny Over a year ago

Try setting DisplayMember and ValueMemeber of the listbox before assigning the datasource ListBox1.DisplayMember = "TABLE_NAME" ListBox1.ValueMember = "TABLE_NAME ListBox1.DataSource = ds.Tables(0)

Abdelouahed EL HARIRI Over a year ago

same problem system.data.grid.row

Collectives™ on Stack Overflow

How to display the names of my SQL Server tables in a listbox using vb.net? [duplicate]

2 Answers 2

5 Comments

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

3 Comments

Linked

Related