Setting Up Your Workspace

In this chapter, your workspace is going to be an ASP.NET Web Form. If you prefer working in an application that's similar to Microsoft's SQL Server Query Analyzer, you also can run all the queries in that.

The first step is to create a new web form. In the example in Listing 4.1, I created one called myqueries.aspx. Listing 4.1 contains the code you're going to be using to walk through the different SQL statements. Since this code is for demonstration purposes only, we won't be spending a lot of time looking at it; by now you should be familiar with most of the ADO.NET code after going through Chapter 2, “What Is ADO.NET?” and Chapter 3, “ADO.NET Managed Providers.” In Chapter 5, “Using a Basic DataGrid,” the DataGrid ...

Get Programming Data-Driven Web Applications with ASP.NET now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.