Creating DataTables through the IDE in an inherited DataSet

  • Thread starter Thread starter john
  • Start date Start date
J

john

In the IDE, if you create a DataSet, you can drag tables from the
Server Explorer and it will automatically create a DataTable for you
inside the DataSet. Is there a way for it to automatically create a
DataTable for you from a "SELECT" statement that you give it. For
example, I have a SELECT statement that has a bunch of JOINs in it. I
would like to have a DataTable that perfectly matches the columns that
are returned from the query.
Thanks in advance.
 
Hi John,

Sure there is.
Drop a dataadapter on the form or some sort of container.
Adjust its select command.
Make sure that select command has a valid connection.
Right click ... Generate Dataset...
 
Back
Top