newbie in search of ADO.NET code samples

[barret bonden]

Can anyone point me to step by step walk-throughs of ADO.NET code - I'd
like to get to the point of being able to programmatically work with
assigning field data to text boxes and then write back changes to the
tables.





As an aside; I started playing with Visual Studio 2003, and now VB 2005
Express. I come out of Dbase/Clipper/Foxpro/Delphi/MSAccess/ PHP-MYSQL- and
I must admit

to being driven out of my mind with datasets and dataadaptors and
datareaders - My eyes water -I just want the *data* - the levels of
abstraction from the data itself have been driving me from the .net
environment- and I'm sure I'm missing out on some good stuff - so far VB'05
has been no different in this way from VS '03 ; I need some
simple -step -by -step working code to build on - the MS Books so far have
lacked this, and the free training videos from MS only take me through a GUI
approach , whereas I want *CODE* - any pointers to this greatly
appreciated.

(While I'm at this - I appreciate the cleverness in MS's disconnected
approach to data - I do wonder however why a connected model (and thus a
simpler one) could not have been offered as well - at least in the more
amateur oriented (if I understand this correctly) VB 2005 Express )

 

[Jerry H.]

If I'm not mistaken the original goal of .NET was to focus on
Internet/Intranet data handling, which by its nature is "disconnected",
thus the lack of "connected" data features. There are a number of
improvements in the 2.0 framework for ADO.NET that gets it closer to
original ADO methods & practices.

Try these links:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnanchor/html/adonetanchor.asp

http://msdn2.microsoft.com/en-us/library/fxsa23t6.aspx