Providing Data Access for Your Web Pages


Much of your Web programming will involve working with data in a database. Web Matrix supports one type of database: Microsoft SQL Server. Web Matrix can work with either of two production versions of SQL Server, SQL Server 7 or SQL Server 2000. If you have one of these versions installed, you re all set.

However, if you ve never worked with databases before, there s a good chance that you don t have either of these versions of SQL Server installed. Fortunately, you can use an alternative called Microsoft SQL Server 2000 Desktop Engine (MSDE 2000). MSDE is a free, redistributable version of the SQL Server engine (without any of the supporting tools) that you can install and use as the database for your Web Matrix work. If you deploy an application to a Web server computer that does have SQL Server installed, the data access components of your application will work exactly the same.

What about other data sources, such as Microsoft Access? ASP.NET supports all manner of databases, including Access. The limitation here is Web Matrix, not ASP.NET. The nice WYSIWYG tools in Web Matrix currently support only SQL Server in its various flavors.




Microsoft ASP. NET Web Matrix Starter Kit
Microsoft ASP.NET Web Matrix Starter Kit (Bpg-Other)
ISBN: 0735618569
EAN: 2147483647
Year: 2003
Pages: 169
Authors: Mike Pope

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net