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

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 Mar 22 '16 at 15:59 — Trevor, Mar 22 '16 at 15:59

Adam Silenko · Accepted Answer · 2016-03-22T19:14:26.767

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 '16 at 19:14

answered Mar 22 '16 at 16:05

Adam Silenko

3,025
1
14
30

2

Or better yet: for tables use `sys.tables` – marc_s Mar 22 '16 at 16:13
i get system.data.grid.rows on my list box – Abdelouahed EL HARIRI Mar 22 '16 at 16:23
did you set sql = "SELECT name FROM sys.tables" ? – Adam Silenko Mar 22 '16 at 16:32
thank you very muck it's working perfectly :) – Abdelouahed EL HARIRI Mar 22 '16 at 19:40
but the question should be: how to set query as DataSource of LsListBox using vb – Adam Silenko Mar 22 '16 at 20:55

score 0 · Answer 2 · answered Mar 22 '16 at 16:01

0

Try this as your sql

sql = "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES"

answered Mar 22 '16 at 16:01

Tonny

109
9

i get system.data.grid.rows on my list box – Abdelouahed EL HARIRI Mar 22 '16 at 16:08
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) – Tonny Mar 22 '16 at 16:13
same problem system.data.grid.row – Abdelouahed EL HARIRI Mar 22 '16 at 16:24

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

2 Answers2