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® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
