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

• Тип: Текст
• Автор: Kevin Ph.D. Hough
• Издательство: Ingram(2020)
• ISBN: 9780983615118
• Страниц: 40
• Язык: Английский

• Жанры: Программы, Базы данных

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.<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.