I posted this on the Database Section with no luck, maybe I will have better luck here.

I am very novice to programming, so please bare with me.

I am working on a couple of projects to help me learn and have an idea for one that I would like to try.

Scope: Create a ListBox that will list all the tables columns for a given table.

Problem: The database I want to use has a LOT!!! of tables in it and when I set my adapter I have to add all those table and columns to it. I am sure there is a better way but not sure, and this is where I am asking for your help.

What I have and know so far.

Have a TextBox Where the user enters the table they want to see the fields.

Have a ListBox to Display Data

Have a Button that will Trigger the Event

PsedoCode

//On_Click Event

DataSet21.Clear()
OracleDataAdapter1.Fill(DataSet21, "TABLENAME")
Dim myTable As DataTable = DataSet21.TABLENAME
Dim col As DataColumn

For Each col In myTable.Columns
ListBox1.Items.Add(col.ColumnName)
Next

End Sub

I Have tested the above code and all is well, but I am not sure what is a good way to to get all the tables into the dataset and adapter without adding all of them.

If you any of you have any suggestions, great!! I would really appriciate it.

Thanks in advance