Beginning SQL Server 2005 Express Database Applications with Visual Basic Express and Visual Web Developer Express (eBook)

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.

Contents at a Glance 4
Contents 6
About the Author 14
About the Technical Reviewer 16
Acknowledgments 18
Introduction 20
PART 1 Working with SQL Server Express 23
CHAPTER 1 Getting Started with SQL Server Express 25
What Is SQL Server Express? 25
Who Is SQL Server Express For? 27
SQL Server Express vs. SQL Server 2005 31
SQL Server Express vs. MSDE 33
Installing SQL Server Express 34
Using SQL Server Express Query Tools 38
Connecting from Remote Down-Level Clients 46
Summary 53
CHAPTER 2 Graphical and Command-Line Query Tools 55
Using the SSMS-Based Query Tool 55
Using the sqlcmd Utility 82
Summary 93
CHAPTER 3 Exploring, Creating, and Recovering Databases 95
Backing Up and Restoring Databases 120
Summary 128
CHAPTER 4 Data Types, Tables, and Constraints 129
Learning About Data Types 129
Creating Tables and Using Data Types 143
Managing Data Integrity with Basic Constraints and Column Properties 150
Managing Data Integrity with Sophisticated Constraints 161
Summary 176
CHAPTER 5 Creating Queries from a Single Database Object 177
Specifying Items to Select from a Data Source 177
Filtering, Grouping, and Aggregating 197
Summary 211
CHAPTER 6 Querying Multiple Database Objects and Manipulating Result Sets 213
Joining Data Sources 213
Using Subqueries 230
Explicitly Ordering and Ranking Rows 237
Manipulating Result Sets 246
Summary 267
CHAPTER 7 Leveraging Database Objects That Encapsulate T-SQL 269
Creating and Using Views 269
Creating and Using User-Defined Functions 281
Creating and Using Stored Procedures 289
Creating and Using Triggers 314
Summary 327
CHAPTER 8 Managing SQL Server Express Security 329
Overview of Security Concepts 329
Exploring and Creating Principals 330
Assigning Permissions to Principals 346
Creating and Using Schemas 370
Using Encryption Keys and Certificates 381
Summary 390
PART 2 Working with Visual Basic Express and Visual Web Developer Express 391
CHAPTER 9 Introduction to Visual Basic Express and Windows Forms 393
Starting, Saving, and Exploring a Solution 393
Using Visual Basic Data Types in VBE 396
Building and Testing a Windows Form Calculator 407
Handling Exceptions 412
Using the File System 419
Summary 430
CHAPTER 10 Introduction to Visual Web Developer Express,Web Pages, and Web Forms 431
ASP.NET Development Concepts 431
Starting and Exploring ASP.NET Projects 433
Creating Pages for an ASP.NET Project 437
Interacting with Data 451
Summary 464
CHAPTER 11 Programming ADO.NET 467
Overview of ADO.NET 467
Programming Connection Objects 469
Programming Command Objects 476
Summary 505
CHAPTER 12 Programming DataAdapter and DataSet Objects 507
Summary 536
CHAPTER 13 Using Visual Database and Form Design Tools 537
Visual Database Tools in VBE 537
Working with Data Sources and Windows Forms 548
Visual Web Developer Visual Database Tools 576
Summary 596
Index 597