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.

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.

Klappentext

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

Zusammenfassung

SQL Server 2005 Express is the database component of Microsoft's Express Suite of products. It is free of charge, inherits many (non-enterprise) features from SQL Server 2005, and comes complete with development and administration tools. As such, it is an ideal database for developers and administrators to use in prototype/evaluation projects. It is also a powerful development platform for database applications on nonprofit websites, e-commerce sites, and in small offices and departments.

Author Rick Dobson provides all of the installation, configuration, administration, and development techniques that you need to build applications quickly. He focuses on techniques that are easy to learn and transparent in their real-world translations. Topics include the SSMS-based query tool and T-SQL programming, and Visual Basic Express and Visual Web Developer, both with SSE, to build Windows Forms applications and to develop ASP.NET web applications.

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.