The Data Access Layer (DAL) was crafted in the first tutorial (Creating a Data Access Layer) and the Business Logic Layer in the second (Creating a Business Logic Layer).Starting with the Displaying Data With the Object Data Source tutorial, we saw how to use ASP.
The menu on the left now includes items for the editing, inserting, and deleting tutorials.
While the Access Data Source is designed to work specifically with Microsoft Access, the Sql Data Source control works with relational database that can be accessed through . This includes any Ole Db- or ODBC-compliant data stores, such as Microsoft SQL Server, Microsoft Access, Oracle, Informix, My SQL, and Postgre SQL, among many others.
The sole difference between the Access Data Source and Sql Data Source controls is how the database connection information is specified.
Microsoft Access is a development environment used to create computer-based databases.
To complement it, it ships with a programming language called Visual Basic For Application (VBA) and various libraries.
These two different controls lead many developers new to ASP.