Visual Basic 2010 Coding Briefs Data Access. Kevin Ph.D. Hough

Аннотация:

In today&#39;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.<br><br>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. <br><br>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.<br><br>The major areas that we will address in this brief are as follows:<br>– Discussing the Data Access Framework (DAL)<br>– Importing Libraries and Declaring Values<br>– Managing the Database Connections<br>– Selecting Records<br>– Manipulating Data<br>– Preparing the Select and Execute Methods<br>– Working with Parameters<br>– Testing the Data Access Framework<br><br>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.