In VS03 I can use a dataadapter to fill multipe tables in a dataset using a
stored proc in SQL2k that returns multiple result sets.

In VS05 B2 the DataAdapter is not in the toolbox by default. I'm sure I can
add it but is there a 'better' way of doing this now with table adapters or
something else?

Hi Jonesie

If you open the Data Sources window in Visual Studio 2005 Beta2 (Data >
Show Data Sources menu option), you can add a data source which will allow
you to data-bind items from the datasource to controls on the Windows Form.
Here is a link to an article in the MSDN pre-release documentation to help
you on your way:

http://msdn2.microsoft.com/library/m...us,vs.80).aspx

thanks

Mike

--

VSData Team
Please post to our newsgroup: microsoft.public.dotnet.datatools
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------

Thanks but DataSources don't work here. You still have to use a data adapter
- at least that's what I've done. Also, DataSources aren't avaialble in web
apps and it's not the binding that is the problem.

As I understand it, DataSets & DataComponents only give you table adapters.
What I'd really like to do is add a DataAdapter to a DataSet designer that
could populate tables in the DataSet. Essentially I've done this manually by
creating a seperate component with the DataAdapter and then having code in
the DataSet to use this.

Thanks
--
Peter G Jones
..Net MVP
New Zealand
http://jonesie.net.nz


"Mike Droney [MSFT]" wrote: