This book provides all of the installation, configuration, administration and development techniques that you need to build these types of application quickly and effectively. It focuses on solution techniques that are easy to learn, fast to implement, and transparent in the ways they address real-world problems. It covers: SQL Server Express tools and techniques, including use of Express Manager, and T-SQL programming. Using Visual Basic Express with SSE to build Windows Forms applications. Using Visual Web Developer with SSE for rapid but effective development of ASP.NET Web applications. The book includes two full example case studies showing how to build a paypal-based eCommerce site and a Church administration application.

First book to demonstrate the full Express Suite of tools to the point where the reader can develop 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

Autorentext

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.

Inhalt
Working with SQL Server Express.- Getting Started with SQL Server Express.- Graphical and Command-Line Query Tools.- Exploring, Creating, and Recovering Databases.- Data Types, Tables, and Constraints.- Creating Queries from a Single Database Object.- Querying Multiple Database Objects and Manipulating Results Sets.- Leveraging Database Objects That Encapsulate T-SQL.- Managing SQL Server Express Security.- Working with Visual Basic Express and Visual Web Developer Express.- to Visual Basic Express and Windows Forms.- to Visual Web Developer Express, Web pages, and Web Forms.- Programming ADO.NET.- Programming DataAdapter and DataSet Objects.- Using Visual Database and Form Design Tool.