sql tables in database

SQL Statement will return you the list of tables in a selected/using database:

SELECT name FROM sysobjects WHERE type = 'U'

you can execute this command in the SQL Command, and then fill the datatable with the results using a SqlDataAdapter

Dim theSQLCommand as new SqlCommand("SELECT name FROM sysobjects WHERE type = 'U')

Dim theDataSet as new DataSet()

Dim theDataAdapter as new SqlDataAdapter(theSQLCommand)

theSqlCommand.Connection = new SqlConnection(connectionString)

theSqlCommand.Connection.Open()

theDataAdapter.Fill(theDataSet)

theSqlCommand.Connection.Close()

results should now be stored in:

theDataSet.Tables(0)

does this help?

ahmedilyas at 2007-8-30 >

to display it in a combo box:

Me.theComboBox.DataSource = theDataTable.DefaultView

Me.theComboBox.DisplayMember = theFieldName

Now, if you are using the datatable approach, then this is fine. Be sure to modify the displaymember property to tell it to "bind" a specific column, such as "Name" from my example

does this help?

ahmedilyas at 2007-8-30 >