The TableAdapter's one-table limitation is in regards to automatically making INSERT, UPDATE, DELETE commands given a Select statement.
There is no such requirement for the Select statement itself, so anything from Sql Server that returns a recordset can be used with the Table Adapters. You'll just have to use the designer to point it to which INSERT/UPDATE/DELETE mechanism you want to use. > -----Original Message----- > From: Discussion of advanced .NET topics. > [mailto:[EMAIL PROTECTED] On Behalf Of Pardee, Roy > Sent: Tuesday, October 31, 2006 13:57 > To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM > Subject: Re: [ADVANCED-DOTNET] noddy quesion about data > access in 2005.... > > But doesn't the TableAdapter just deal w/one table? I didn't > think you could have one hit a sproc that returned say, 4 > different recordsets in one go & shunt each one off to the > appropriate DataTable in your DataSet. > > If you can tell what I'm trying to say... > > -----Original Message----- > From: Discussion of advanced .NET topics. > [mailto:[EMAIL PROTECTED] On Behalf Of Vince P > Sent: Tuesday, October 31, 2006 11:55 AM > To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM > Subject: Re: [ADVANCED-DOTNET] noddy quesion about data > access in 2005.... > > You should look into the TableAdapter's functionality in the > DataSet designer in 2.0. > > > > > -----Original Message----- > > From: Discussion of advanced .NET topics. > > [mailto:[EMAIL PROTECTED] On Behalf Of > Pardee, Roy > > Sent: Tuesday, October 31, 2006 13:27 > > To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM > > Subject: Re: [ADVANCED-DOTNET] noddy quesion about data access in > > 2005.... > > > > The thing I miss is the GUI designers for the dataadapters--AFAICT, > > those are no longer designable components. > > > > (Hey, I didn't spend <whatever> on vs 2005 to write the code > > *myself* you know... ;-) > > > > -----Original Message----- > > From: Discussion of advanced .NET topics. > > [mailto:[EMAIL PROTECTED] On Behalf Of > Julia Lerman > > Sent: Tuesday, October 31, 2006 8:46 AM > > To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM > > Subject: Re: [ADVANCED-DOTNET] noddy quesion about data access in > > 2005.... > > > > You can still work with the dataset the way you are used to. > > The difference with vs2005 (well, with ado.net 2.0) is that > they have > > exposed more granular functionality as well as made datatables > > ixmlserializable, which gives datatables many of the same > capabilities > > > that were previously only available to the dataset. So in the long > > run, you just have more options. > > > > hth > > > > Julie > > > > > > > > -----Original Message----- > > From: Discussion of advanced .NET topics. > > [mailto:[EMAIL PROTECTED] On Behalf Of Mark > > Nicholls > > Sent: Tuesday, October 31, 2006 11:30 AM > > To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM > > Subject: [ADVANCED-DOTNET] noddy quesion about data access > in 2005.... > > > > Sounds wierd but I actually haven't that much data access in > > 2003 or 2005....but what I did do in 2003 was along the lines of.... > > > > i) create typed dataset with multiple tables + relations etc. > > ii) write stored procedures that would fill in the whole > dataset based > > > on different criteria..... > > > > e.g. 2 tables... > > > > Owners, Dogs > > > > Select Owners.* From Owners where Owners.Name = @param1 > Select Dogs.* > > From Dogs INNER JOIN owners ON .... and Owners.Name = @param1 > > > > now in 2005, things seem to have migrated to a slightly more table > > gateway oriented sort of thing. > > > > it's as if we're now supposed to incrementally populate > datatables one > > > by one.....I'm not sure if this makes sense though in the > context of a > > > dataset. > > > > =================================== > > This list is hosted by DevelopMentorR http://www.develop.com > > > > View archives and manage your subscription(s) at > > http://discuss.develop.com > > > > =================================== > > This list is hosted by DevelopMentor(r) http://www.develop.com > > > > View archives and manage your subscription(s) at > > http://discuss.develop.com > > > > =================================== > > This list is hosted by DevelopMentor. http://www.develop.com > > > > View archives and manage your subscription(s) at > > http://discuss.develop.com > > =================================== > This list is hosted by DevelopMentor(r) http://www.develop.com > > View archives and manage your subscription(s) at > http://discuss.develop.com > > =================================== > This list is hosted by DevelopMentor. http://www.develop.com > > View archives and manage your subscription(s) at > http://discuss.develop.com =================================== This list is hosted by DevelopMentor® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
