O'Reilly logo

ADO.NET Programming in Visual Basic™ .NET by Bob Howell, Steve Holzner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Views and the Query Designer

Views and the query designer fit together naturally because you use the query designer to create views. A view is a preconfigured select query that is stored in the database and can be used just like a table. In most cases, views can be updated just like queries. One of the most common uses for views is when creating reports. You do not have to use the query designer to create views. You can also create them using a Transact-SQL script. We will look at that method later when we examine the database project. For now we will use the query designer.

To open the query designer (see Figure 3.19), first we must find the views. Using the Server Explorer, navigate to and expand the Northwind database. Expand the Views tab ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required