Yes, these references will help a great deal. It will take me soem time to peruse throlugh all of them, but well worth the effort!
Thank you, Farhad. This helps a lot.
>> what component to use for data access?
ADO.NET provides access to data sources (There are other solutions depend on data type, I/O, XML, LINQ, ...).
http://msdn.microsoft.com/en-us/library/h43ks021%28VS.71%29.aspx"ADO.NET provides consistent access to data sources such as Microsoft SQL Server, as well as data sources exposed through OLE DB and XML. Data-sharing consumer applications can use ADO.NET to connect to these data sources and retrieve, manipulate, and update data."
"ADO.NET cleanly factors data access from data manipulation into discrete components that can be used separately or in tandem. ADO.NET includes .NET Framework data providers for connecting to a database, executing commands, and retrieving results. Those results are either processed directly, or placed in an ADO.NET DataSet object in order to be exposed to the user in an ad-hoc manner, combined with data from multiple sources, or remoted between tiers. The ADO.NET DataSet object can also be used independently of a .NET Framework data provider to manage data local to the application or sourced from XML."
ADO.NET by Joe Mayo
http://www.csharp-station.com/Tutorials/AdoDotNet/Lesson01.aspxADO.NET Code Examples
http://msdn.microsoft.com/en-us/library/dw70f090.aspxADO.NET Sample Application
http://msdn.microsoft.com/en-us/library/dw70f090%28VS.80%29.aspxValuable articles on ADO.NET by David Hayden
http://www.davidhayden.com/articles.aspx#ADONET... and a lot more available online.
Hope this helps