Fill Dataset with Multiple Tables

[Robert Bevington]

Is it possible to fill a predefined dataset with all the tables of a
database without knowing what the table names are. The SQL string would be
something like this: SELECT * FROM *. I want write this in code and not
using the Visual Studio UI.

Just doesn't work for me.

Thanx for any help,

Rob

 

[Cor Ligthert [MVP]]

Rob,

You have to know the schema, with the SQLClient Connection is that easy to
get by the way.

Have a look at this at our website how to do that.

http://www.vb-tips.com/default.aspx?ID=9e2d9af4-3909-421d-b422-87c1d376674d

I hope this helps,

Cor