database to dataset...

[marvinklein]

when I use OleDBDataAdapter with arguments (Command, Connection) my command is always "SELECT * FROM tableName".
then I use DataAdapter.Fill(myDataSet)
how can i use it to fill from the whole Database and not just the one table i specify in the command string?

[Pirate]

Either you use multiple DataTable objects then add them to DataTableCollection of the dataset you're working with
or include as many tables as you really need in the command SQL String like this if I'm right .

"SELECT * FROM tableName,tabletwo,tablethree".