Skip to Content
ASP.NET Cookbook
book

ASP.NET Cookbook

by Michael A Kittel, Geoffrey T. LeBlond
August 2004
Intermediate to advanced
848 pages
23h
English
O'Reilly Media, Inc.
Content preview from ASP.NET Cookbook

Sample Database, Scripts, and Connection Strings

As for the database that is used in the samples, it also can be found at http://www.dominiondigital.com/AspNetCookbook/. The database used for all samples is a SQL Server 2000 database.

As you browse the different sample programs throughout the book, you will see that our preferred method of data access is OLE DB. From our experience writing applications for corporate clients, we have learned that many projects start out using SQL Server but migrate to other database servers, such as Oracle or DB2, during the life of the project. By using OLE DB for data access, we gain the necessary layer of abstraction to easily switch database platforms when and if we need to without having to change the underlying source code. Nevertheless, when you know that SQL Server will be your database platform for the long run, you will undoubtedly want to use SQL Provider to improve its performance, and Recipe 16.4 will show you how.

The connection string used in the samples throughout the book is shown next. It designates the server as localhost, the database as ASPNetCookbook, the database user as ASPNetCookbook_User, and the password for the user as w0rk. You will need to change these parameters to conform to your database installation.

Provider=SQLOLEDB;Data Source=localhost;
Initial Catalog=ASPNetCookbook;
UID=ASPNetCookbook_User;
PWD=w0rk"
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

ASP.NET 2.0 Cookbook, 2nd Edition

ASP.NET 2.0 Cookbook, 2nd Edition

Michael A Kittel, Geoffrey T. LeBlond
C# Cookbook

C# Cookbook

Stephen Teilhet, Jay Hilyard
C# Cookbook

C# Cookbook

Joe Mayo

Publisher Resources

ISBN: 0596003781Catalog PageErrata