Publisher review:.Net DataAccess 2002 is a class for all DB I/O services. Purpose:
The DataAccessLayer component is a class for all DB I/O services. ' This includes overloaded GetData, SaveData, ExecuteNonQuery, ExecuteScalar methods for OLEDB, SQLServer & DB2 databases. ' Access to the DB2 databases has a choice of two different providers (Microsoft or DB2). ' Use the "SaveData" methods when you are concerned about database concurrency issues.
The SaveData methods return updated data ' in a dataset and can then be further queried for concurrency issues. ' The various methods also include different ways of the data being passed to this class like in datasets, datatables, datarows, etc. '
In addition, you pass an "UpdateType" argument in these methods which will tell .Net how to proceed in case of an error occurring on an UPDATE statement (like concurrency, for instance). ' The possible .Net "UpdateType"s are: Continue, ErrorsOccurred, SkipAllRemainingRows, SkipCurrentRow which are self explanatory.
' Everyone but "ErrorsOccurred" will NOT generate an exException, rather, these rows will be flagged as having errors and you can process them accordingly at your client level. ' Every possible error exException for all methods are handled. ' Use the "ExecuteNonQuery" methods when you are not concerned about concurrency issues and don't want the records back in a datset. '
Use the "ExecuteScalar" methods to return just one value (for instance an aggregate value) from a database. ' Use the "ExecuteReader" methods to return a forward-only cursor ' The Command or DataAdapter objects in each of the "GetData" & "ExecuteNonQuery" methods have a reference to them because of the ' need to possibly retrieve Command parameter values from them.
.Net DataAccess 2002 is a ASP.NET script for Database Tools scripts design by YeagerTech Consulting, Inc.
It runs on following operating system: Windows.
.Net DataAccess 2002 is a class for all DB I/O services.
Operating system:Windows