Ebook75 pages33 minutes
Visual Basic 2010 Coding Briefs Data Access
By Kevin Hough
Rating: 5 out of 5 stars
5/5
()
About this ebook
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.
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.
Related to Visual Basic 2010 Coding Briefs Data Access
Related ebooks
Visual Basic Programming:How To Develop Information System Using Visual Basic 2010, A Step By Step Guide For Beginners Rating: 4 out of 5 stars4/5SQL CODING FOR BEGINNERS: Step-by-Step Beginner's Guide to Mastering SQL Programming and Coding (2022 Crash Course for Newbies) Rating: 0 out of 5 stars0 ratingsCreating your MySQL Database: Practical Design Tips and Techniques Rating: 3 out of 5 stars3/5MySQL Management and Administration with Navicat Rating: 0 out of 5 stars0 ratingsOracle SQL Developer Rating: 0 out of 5 stars0 ratingsC# For Beginners: An Introduction to C# Programming with Tutorials and Hands-On Examples Rating: 0 out of 5 stars0 ratingsC# for Beginners: Learn in 24 Hours Rating: 0 out of 5 stars0 ratingsASP.NET For Beginners: The Simple Guide to Learning ASP.NET Web Programming Fast! Rating: 0 out of 5 stars0 ratingsLearn T-SQL Querying: A guide to developing efficient and elegant T-SQL code Rating: 0 out of 5 stars0 ratingsPython and SQLite Development Rating: 0 out of 5 stars0 ratingsVisual Basic .NET for complete beginners Rating: 5 out of 5 stars5/5Learning Oracle 12c: A PL/SQL Approach Rating: 0 out of 5 stars0 ratingsVisual Basic 6.0 Programming By Examples: 7 Windows Application Examples Rating: 3 out of 5 stars3/5Start-to-Finish Visual C# 2015 Rating: 5 out of 5 stars5/5Excel VBA Programming: Automating Excel through Visual Basic for Application Rating: 0 out of 5 stars0 ratingsExcel VBA: A Beginners' Guide Rating: 4 out of 5 stars4/5The Programmer’s Guide to Microsoft Access Rating: 5 out of 5 stars5/5Secrets of Access Database Development and Programming Rating: 5 out of 5 stars5/5Relational Database Systems Rating: 0 out of 5 stars0 ratingsVb Net Programming Rating: 0 out of 5 stars0 ratingsMs Access 2007: Step by Step Rating: 5 out of 5 stars5/5SQL Database Programming: The Ultimate Guide to Learning SQL Database Programming Fast! Rating: 0 out of 5 stars0 ratingsAutoIT Scripting For Beginners Rating: 5 out of 5 stars5/5Json for Beginners: Your Guide to Easily Learn Json In 7 Days Rating: 3 out of 5 stars3/5Python: Beginner's Guide to Programming Code with Python: Python Computer Programming, #1 Rating: 0 out of 5 stars0 ratingsMastering PL/SQL Through Illustrations: From Learning Fundamentals to Developing Efficient PL/SQL Blocks (English Edition) Rating: 0 out of 5 stars0 ratingsOracle SQL and PL/SQL Rating: 5 out of 5 stars5/5Introduction to C++ Programming Rating: 3 out of 5 stars3/5
Programming For You
HTML & CSS: Learn the Fundaments in 7 Days Rating: 4 out of 5 stars4/5Python Programming : How to Code Python Fast In Just 24 Hours With 7 Simple Steps Rating: 4 out of 5 stars4/5SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL Rating: 4 out of 5 stars4/5Learn PowerShell in a Month of Lunches, Fourth Edition: Covers Windows, Linux, and macOS Rating: 0 out of 5 stars0 ratingsLearn to Code. Get a Job. The Ultimate Guide to Learning and Getting Hired as a Developer. Rating: 5 out of 5 stars5/5The Unofficial Guide to Open Broadcaster Software: OBS: The World's Most Popular Free Live-Streaming Application Rating: 0 out of 5 stars0 ratingsCoding All-in-One For Dummies Rating: 4 out of 5 stars4/5Java for Beginners: A Crash Course to Learn Java Programming in 1 Week Rating: 5 out of 5 stars5/5Hacking: Ultimate Beginner's Guide for Computer Hacking in 2018 and Beyond: Hacking in 2018, #1 Rating: 4 out of 5 stars4/5Grokking Algorithms: An illustrated guide for programmers and other curious people Rating: 4 out of 5 stars4/5Python Projects for Beginners: A Ten-Week Bootcamp Approach to Python Programming Rating: 0 out of 5 stars0 ratingsSQL: For Beginners: Your Guide To Easily Learn SQL Programming in 7 Days Rating: 5 out of 5 stars5/5PYTHON: Practical Python Programming For Beginners & Experts With Hands-on Project Rating: 5 out of 5 stars5/5Excel : The Ultimate Comprehensive Step-By-Step Guide to the Basics of Excel Programming: 1 Rating: 5 out of 5 stars5/5Python: For Beginners A Crash Course Guide To Learn Python in 1 Week Rating: 4 out of 5 stars4/5SQL All-in-One For Dummies Rating: 3 out of 5 stars3/5The Little SAS Book: A Primer, Sixth Edition Rating: 5 out of 5 stars5/5Teach Yourself C++ Rating: 4 out of 5 stars4/5Pokemon Go: Guide + 20 Tips and Tricks You Must Read Hints, Tricks, Tips, Secrets, Android, iOS Rating: 5 out of 5 stars5/5Web Designer's Idea Book, Volume 4: Inspiration from the Best Web Design Trends, Themes and Styles Rating: 4 out of 5 stars4/5
Reviews for Visual Basic 2010 Coding Briefs Data Access
Rating: 5 out of 5 stars
5/5
1 rating0 reviews
Book preview
Visual Basic 2010 Coding Briefs Data Access - Kevin Hough
Enjoying the preview?
Page 1 of 1