Scheduled Dates (sort by: location | date) |
Request availability or book by selecting a date: England
Prices exclude VAT.
Have questions or need a better city/date? Ask now.
On-site/international quote? Ask now.
|
Course Overview The course will enable delegates to utilise ADO.NET to develop database applications with Visual Studio .NET. The course will cover how to connect databases to both Windows and Web Applications. Audience Competent Visual Basic .NET programmers who wish to utilise Microsoft's latest database objects in their code. Those delegates working towards MCTS or MCPD .NET certification. Prerequisites Delegates should have experience of Object Oriented programming techniques. Attendance on our .NET Object Oriented courses will give the necessary knowledge. For those wishing to write Data-driven Web sites, attendance on our Developing Web Applications with ASP.NET would be useful. Course Overview CONNECTING TO DATABASES FROM WINDOWS APPLICATIONS CONNECTING TO DATABASES FROM WEB APPLICATIONS - Web vs. Windows Apps
- Data Bound Controls
- Configuring a Data Source
- DataSource Controls
- The SQLDataSource Control
- The ObjectDataSource Control
- The XMLDataSource Control
ENCRYPTING CONNECTION STRINGS - Connection Strings
- Encrypting/Decrypting in code
- Windows Apps
- Web Apps Using aspnet_regiis
- Web Apps done in Code
N-TIER APPLICATIONS - Types of N-Tier Apps
- 2 Tiers - a DAL and a PL
- Create the DAL
- Create a Windows PL
- Create a Web PL
3-TIER WITH DATASETS AND DATATABLES - A 3-Tier Example
- Create the BOL
- Point the Win PL at the BOL
- Create a Web PL
- Point the Web PL at the BOL
- Enable Filtering
- Enable Updates
- Enable Inserts
- Business Objects
- Create the BOL
- Create a Web PL
- Enable Sorting
- Viewing Customer Details
- Enable Deleting
- Enable Updates
- Enable Inserts
- Create a Win PL
3-TIER WITH CUSTOM DAL - Create the DAL
- Create the BOL
- Create the PL
- Viewing Customer Details
- Enable Deleting
- Enable Updates
- Enable Inserts
CACHING - Caching Based on Timeouts
- SQL Server Profiler
- Manually Expiring the Cache
- Caching based on Changes to the Database
- API-based Caching
How to make a booking for the MAD2-IN course
|
