Data access techniques

+1 for rockys book...

been using his frameowrk stuff for the last 18
months...works well for the
apps ive needed to create.


-----Original Message-----
From: Discussion of writing applications and components
using Visual
Basic .NET [mailto:VBDOTNETDISCUSS.DEVELOP.COM]On
Behalf Of Tobek
Sent: Monday, March 27, 2006 11:01 AM
To: VBDOTNETDISCUSS.DEVELOP.COM
Subject: Re: [VBDOTNET] Data access techniques


Jason, if your're using VB 2005 rather than 2002 or 2003,
then getting hold
of
a copy of Brain Noyes' book on databinding with Winforms
would help you a
lot.
The code examples are in C#, but that's not a big issue for
understanding
the
code or translating it to VB. Samples in this book focus
mostly on binding
to
XML data such as datasets, but there's also a chapter on
object binding.

Databinding in the VS 2003 version has a number of quirks
that have been
improved or solved in VS 2005.

To get an overview of the rationale for building tiered data
access systems
(for Winforms or Web apps) using an OO approach, based on
the .Net 2002/2003
editions I'd highly recommend Rocky Lhotka's Business
Objects book(s). The
C#
2005 version has just be released; the VB 2005 version is
due out in a
couple
of weeks.

A core reference on ADO.Net would be also valuable.

Quoting Jason <vbdotnetPINEAPPLELANE.COM>:

> I definitely need it, thanks!
>
> Jason
>
> At 07:51 PM 3/26/2006, you wrote:
> >Jason,
> >
> >I won't address all your issues, but I will give
you two things to
> >consider.
> >
> >This part of your code:
> >
> >          cmd.CommandText = "SELECT ClientID,
EntityID, EntryTypeID,
> >ClientLName, ClientFName, ClientMName, "
& _
> >              "ClientSuffix, SpouseLName,
SpouseFName, SpouseMName,
> >SpouseSuffix, Inactive FROM ClientAdvantage."
& _
> >              "dbo.Clients WHERE ClientID =
" & intClientID
> >
> >suggests you may want to read up on parameterised
queries / sql
injection.
> >http://www.4guysfromrolla.com/webtech/092601-1.2.shtml
is as good as
place
> >as any to start.
> >
> >Also,
> >http://msdn.microsoft.com/library/default.asp?url=
/library/en-
us/cpref/html/frlrfsystemdatasqlclientsqlcommandclassexecute
readertopic.asp
> >  suggests you may want to call dr.Read before
trying to get its values.
> >
> >Seeya
> >Matthew Wills  MLC
> >Senior Analyst Programmer
>
> ===================================
> This list is hosted by DevelopMentorŪ  http://www.develop.com
>
> View archives and manage your subscription(s) at
http://discuss.develop.com

>




------------------------------------------------------
This message was sent using Delmarva Online's Webmail.
http://www.dmv.com/

===================================
This list is hosted by DevelopMentorŪ  http://www.develop.com

View archives and manage your subscription(s) at http://discuss.develop.com


--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.385 / Virus Database: 268.3.2/293 - Release
Date: 3/26/2006

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.385 / Virus Database: 268.3.2/293 - Release
Date: 3/26/2006

===================================
This list is hosted by DevelopMentorŪ  http://www.develop.com

View archives and manage your subscription(s) at http://discuss.develop.com

Thanks to both of you.  I actually have a few ADO.NET books
but they seem
to be very basic.  It may seem contradictory to say that
since I am new and
need such a book, but I am referring to the sample
scenarios.  I need
something that teaches me how to build real applications and
the "Hello
World" variety aren't helping me much.

Thanks for the referral on the books, and I'll have to
start with Rocky's
book.  I am interested in building some reusable objects.  I
have a lot
more to go in my journey, but not too bad if you consider
that I'm an
accountant!!!

Jason

At 11:13 AM 3/27/2006, you wrote:
>+1 for rockys book...
>
>been using his frameowrk stuff for the last 18
months...works well for the
>apps ive needed to create.
>
>
>-----Original Message-----
>From: Discussion of writing applications and components
using Visual
>Basic .NET [mailto:VBDOTNETDISCUSS.DEVELOP.COM]On
Behalf Of Tobek
>Sent: Monday, March 27, 2006 11:01 AM
>To: VBDOTNETDISCUSS.DEVELOP.COM
>Subject: Re: [VBDOTNET] Data access techniques
>
>
>Jason, if your're using VB 2005 rather than 2002 or
2003, then getting hold
>of
>a copy of Brain Noyes' book on databinding with
Winforms would help you a
>lot.
>The code examples are in C#, but that's not a big issue
for understanding
>the
>code or translating it to VB. Samples in this book focus
mostly on binding
>to
>XML data such as datasets, but there's also a chapter
on object binding.
>
>Databinding in the VS 2003 version has a number of
quirks that have been
>improved or solved in VS 2005.
>
>To get an overview of the rationale for building tiered
data access systems
>(for Winforms or Web apps) using an OO approach, based
on the .Net 2002/2003
>editions I'd highly recommend Rocky Lhotka's Business
Objects book(s). The
>C#
>2005 version has just be released; the VB 2005 version
is due out in a
>couple
>of weeks.
>
>A core reference on ADO.Net would be also valuable.

===================================
This list is hosted by DevelopMentorŪ  http://www.develop.com

View archives and manage your subscription(s) at http://discuss.develop.com

rocky's book really helped me move away from thinking of
objects in terms of
how they are laid out in the database, and much more towards
the
mantra.....objects are defined by behaviour, not
data....stops you thinking
in terms of records and recordsets....very useful when you
are trying to
make an application perform a certain task...or exhibit a
certain behaviour.


-----Original Message-----
From: Discussion of writing applications and components
using Visual Basic
.NET [mailto:VBDOTNETDISCUSS.DEVELOP.COM]On Behalf Of Jason
Sent: Monday, March 27, 2006 9:10 PM
To: VBDOTNETDISCUSS.DEVELOP.COM
Subject: Re: [VBDOTNET] Data access techniques


Thanks to both of you.  I actually have a few ADO.NET books
but they seem
to be very basic.  It may seem contradictory to say that
since I am new and
need such a book, but I am referring to the sample
scenarios.  I need
something that teaches me how to build real applications and
the "Hello
World" variety aren't helping me much.

Thanks for the referral on the books, and I'll have to
start with Rocky's
book.  I am interested in building some reusable objects.  I
have a lot
more to go in my journey, but not too bad if you consider
that I'm an
accountant!!!

Jason

At 11:13 AM 3/27/2006, you wrote:
>+1 for rockys book...
>
>been using his frameowrk stuff for the last 18
months...works well for the
>apps ive needed to create.
>
>
>-----Original Message-----
>From: Discussion of writing applications and components
using Visual
>Basic .NET [mailto:VBDOTNETDISCUSS.DEVELOP.COM]On
Behalf Of Tobek
>Sent: Monday, March 27, 2006 11:01 AM
>To: VBDOTNETDISCUSS.DEVELOP.COM
>Subject: Re: [VBDOTNET] Data access techniques
>
>
>Jason, if your're using VB 2005 rather than 2002 or
2003, then getting hold
>of
>a copy of Brain Noyes' book on databinding with
Winforms would help you a
>lot.
>The code examples are in C#, but that's not a big issue
for understanding
>the
>code or translating it to VB. Samples in this book focus
mostly on binding
>to
>XML data such as datasets, but there's also a chapter
on object binding.
>
>Databinding in the VS 2003 version has a number of
quirks that have been
>improved or solved in VS 2005.
>
>To get an overview of the rationale for building tiered
data access systems
>(for Winforms or Web apps) using an OO approach, based
on the .Net
2002/2003
>editions I'd highly recommend Rocky Lhotka's Business
Objects book(s). The
>C#
>2005 version has just be released; the VB 2005 version
is due out in a
>couple
>of weeks.
>
>A core reference on ADO.Net would be also valuable.

===================================
This list is hosted by DevelopMentor.  http://www.develop.com

View archives and manage your subscription(s) at http://discuss.develop.com


--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.385 / Virus Database: 268.3.2/293 - Release
Date: 3/26/2006

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.385 / Virus Database: 268.3.2/293 - Release
Date: 3/26/2006

===================================
This list is hosted by DevelopMentorŪ  http://www.develop.com

View archives and manage your subscription(s) at http://discuss.develop.com

I'm sold!  Many thanks to each of you for taking the time
to reply.  I'll
have to afford myself a copy of Rocky's book and get
started!

Kindest regards,

Jason

At 08:47 AM 3/28/2006, you wrote:
>rocky's book really helped me move away from thinking
of objects in terms of
>how they are laid out in the database, and much more
towards the
>mantra.....objects are defined by behaviour, not
data....stops you thinking
>in terms of records and recordsets....very useful when
you are trying to
>make an application perform a certain task...or exhibit
a certain behaviour.

===================================
This list is hosted by DevelopMentorŪ  http://www.develop.com

View archives and manage your subscription(s) at http://discuss.develop.com

Another one drinks the KoolAid 

Rocky's just been on DotNetRocks talking about the new
version of the CSLA
framework: http://www.dotnetrocks.c
om/. He'll also be doing some DNR TV
epidodes about it as well: http://dnrtv.com/


-----Original Message-----
From: Discussion of writing applications and components
using Visual Basic
.NET [mailto:VBDOTNETDISCUSS.DEVELOP.COM] On Behalf Of Jason
Sent: Wednesday, 29 March, 2006 8:45 PM
To: VBDOTNETDISCUSS.DEVELOP.COM
Subject: Re: [VBDOTNET] Data access techniques

I'm sold!  Many thanks to each of you for taking the time
to reply.  I'll
have to afford myself a copy of Rocky's book and get
started!

Kindest regards,

Jason

At 08:47 AM 3/28/2006, you wrote:
>rocky's book really helped me move away from thinking
of objects in
>terms of how they are laid out in the database, and much
more towards
>the mantra.....objects are defined by behaviour, not
data....stops you
>thinking in terms of records and recordsets....very
useful when you are
>trying to make an application perform a certain
task...or exhibit a certain
behaviour.

===================================
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