I am a C# developer in ADO.NET and need assistance with a – I assume –
simple question:

How do I get all the data from a database in a dataset? I want to be
able to open any kind of ODBC database and thus do not have any
knowledge of the names of the tables or fields contained in the
database. I could after a day of searching on the Internet not find
ONE example where you don't have to specify which tables you want your
dataset to be populated with.

Thanks in advance

There is an example in the Visual Studio help:

ms-help://MS.VSCC/MS.MSDNVS/ado270/htm/mdmthopenschemax.htm

>> I want to be able to open any kind of ODBC database and thus do
not have any knowledge of the names of the tables or fields [sic]
contained in the database. <<

You can get to the schema information tables and read them, since they
have standardized names and structures, then you use them to discover
the stuff in the database. It is insanely complicated. The best
answer is that you actually should know what you are doing before you
do it.

Hi Piere,

You should write a SQL statement to investigate all the tables in your
database.
and execute that with a command.executeQuery

And than make a select for every table.

There is not a SQL statement.
Select * from * as far as I know.
However my knowledge of SQL is fair, because I hate it.

Than I think you can even do when you set the names in a table
\\\
For i as integer = 0 to myTalblenameArray.length - 1
dataadatper.fill(dataset, myTablenameArray(i))
next
///
I hope this helps?

Cor