Dobson Beginning SQL Server 2005 Express Database Applications with Visual Basic Express and Visual Web Developer Express

From Novice to Professional
1. ed
ISBN: 978-1-4302-0108-3
Verlag: Apress
Format: PDF
Kopierschutz: 1 - PDF Watermark

E-Book, Englisch, 624 Seiten

* First book to demonstrate the full Express Suite of tools to the point where the reader can developer effective, low-budget database applications for non-profit web sites or for commercial tactical solutions. * Will capture the wave of application developers migrating from traditional VB/Access database to the .NET approach. * Full cases studies showing how to build e-Commerce and Web applications. * Readers will gain a sufficient grasp of the SQL Server and .NET fundamentals that they can readily grow their skills for clients whose needs escalate over time.

Rick Dobson has authored six books on database development with Visual Basic .NET, SQL Server, and Microsoft Access. In the past few years, he authored three DVDs on Visual Basic .NET, ADO.NET, and T-SQL. In addition, Dobson has written countless articles for computer periodicals, including SQL Server Magazine, Visual Studio .NET Developer, Visual Basic Developer, SQL Server Professional, SQL Server Solutions, Inside Microsoft Visual Basic, and Smart Access. Dobson is also the webmaster for several web sites. His most popular site, ProgrammingMSAccess.com, focuses on the needs of VB .NET and SQL Server developers as well as Access developers. This site gets over one million page views annually, and thousands of site visitors register to receive a newsletter summarizing new developments and opportunities on the site. Dobson also founded the Database Developers Group, an international association of Microsoft database developers.

Autoren/Hrsg.

Dobson, Rick

Inhaltsverzeichnis

1;Contents at a Glance;4
2;Contents;6
3;About the Author;14
4;About the Technical Reviewer;16
5;Acknowledgments;18
6;Introduction;20
7;PART 1 Working with SQL Server Express;23
7.1;CHAPTER 1 Getting Started with SQL Server Express;25
7.1.1;What Is SQL Server Express?;25
7.1.2;Who Is SQL Server Express For?;27
7.1.3;SQL Server Express vs. SQL Server 2005;31
7.1.4;SQL Server Express vs. MSDE;33
7.1.5;Installing SQL Server Express;34
7.1.6;Using SQL Server Express Query Tools;38
7.1.7;Connecting from Remote Down-Level Clients;46
7.1.8;Summary;53
7.2;CHAPTER 2 Graphical and Command-Line Query Tools;55
7.2.1;Using the SSMS-Based Query Tool;55
7.2.2;Using the sqlcmd Utility;82
7.2.3;Summary;93
7.3;CHAPTER 3 Exploring, Creating, and Recovering Databases;95
7.3.1;Backing Up and Restoring Databases;120
7.3.2;Summary;128
7.4;CHAPTER 4 Data Types, Tables, and Constraints;129
7.4.1;Learning About Data Types;129
7.4.2;Creating Tables and Using Data Types;143
7.4.3;Managing Data Integrity with Basic Constraints and Column Properties;150
7.4.4;Managing Data Integrity with Sophisticated Constraints;161
7.4.5;Summary;176
7.5;CHAPTER 5 Creating Queries from a Single Database Object;177
7.5.1;Specifying Items to Select from a Data Source;177
7.5.2;Filtering, Grouping, and Aggregating;197
7.5.3;Summary;211
7.6;CHAPTER 6 Querying Multiple Database Objects and Manipulating Result Sets;213
7.6.1;Joining Data Sources;213
7.6.2;Using Subqueries;230
7.6.3;Explicitly Ordering and Ranking Rows;237
7.6.4;Manipulating Result Sets;246
7.6.5;Summary;267
7.7;CHAPTER 7 Leveraging Database Objects That Encapsulate T-SQL;269
7.7.1;Creating and Using Views;269
7.7.2;Creating and Using User-Defined Functions;281
7.7.3;Creating and Using Stored Procedures;289
7.7.4;Creating and Using Triggers;314
7.7.5;Summary;327
7.8;CHAPTER 8 Managing SQL Server Express Security;329
7.8.1;Overview of Security Concepts;329
7.8.2;Exploring and Creating Principals;330
7.8.3;Assigning Permissions to Principals;346
7.8.4;Creating and Using Schemas;370
7.8.5;Using Encryption Keys and Certificates;381
7.8.6;Summary;390
8;PART 2 Working with Visual Basic Express and Visual Web Developer Express;391
8.1;CHAPTER 9 Introduction to Visual Basic Express and Windows Forms;393
8.1.1;Starting, Saving, and Exploring a Solution;393
8.1.2;Using Visual Basic Data Types in VBE;396
8.1.3;Building and Testing a Windows Form Calculator;407
8.1.4;Handling Exceptions;412
8.1.5;Using the File System;419
8.1.6;Summary;430
8.2;CHAPTER 10 Introduction to Visual Web Developer Express,Web Pages, and Web Forms;431
8.2.1;ASP.NET Development Concepts;431
8.2.2;Starting and Exploring ASP.NET Projects;433
8.2.3;Creating Pages for an ASP.NET Project;437
8.2.4;Interacting with Data;451
8.2.5;Summary;464
8.3;CHAPTER 11 Programming ADO.NET;467
8.3.1;Overview of ADO.NET;467
8.3.2;Programming Connection Objects;469
8.3.3;Programming Command Objects;476
8.3.4;Summary;505
8.4;CHAPTER 12 Programming DataAdapter and DataSet Objects;507
8.4.1;Summary;536
8.5;CHAPTER 13 Using Visual Database and Form Design Tools;537
8.5.1;Visual Database Tools in VBE;537
8.5.2;Working with Data Sources and Windows Forms;548
8.5.3;Visual Web Developer Visual Database Tools;576
8.5.4;Summary;596
9;Index;597