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
