Skip to content
eBook Charts
UK
Visual Basic 2010 Coding Briefs Data Access

Visual Basic 2010 Coding Briefs Data Access

Kevin Hough

£6.99

Buy on Amazon View on Apple Books

Prefer it in print? See every format on Amazon →

Price on Apple Books. Amazon’s price may differ.

Read a lot? Try Kindle+ * · Compare subscriptions

Published
Genres
DatabasesComputers & InternetComputers

On the charts

PositionBestDays
Databases #47 #484
For authors: put this badge on your website

Copy this code into your website or blog:

Description

In today's high-tech, information driven world, the security of personal data is vital. We have all heard the horror stories of personal data being compromised from companies, both large and small.

The data access framework that we will develop in Coding Briefs will allow us to create datasets, execute queries, and select data in a secure, managed process. 

This framework will provide a solid foundation for managing secure data access through stored procedures, allowing us to select, insert, update, and delete records from a SQL Server database. We will have access to parameterized queries and will develop an automated process for discovering stored procedure parameters.

The major areas that we will address in this brief are as follows:
- Discussing the Data Access Framework (DAL)
- Importing Libraries and Declaring Values
- Managing the Database Connections
- Selecting Records
- Manipulating Data
- Preparing the Select and Execute Methods
- Working with Parameters
- Testing the Data Access Framework

And, as a bonus, two complete sample applications have been added; one for Windows, and one in ASP .Net, that will test all of the features on the data access framework.

You might also like