Home All Groups Group Topic Archive Search About

Fill Dataset with Multiple Tables

Author
19 Feb 2006 10:14 PM
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

Author
20 Feb 2006 7:10 AM
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

AddThis Social Bookmark Button