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

The Select Command

First, let’s look at the Select statement. In order to do this, we must complete the wizard. Click to close the Advanced SQL Generation Options dialog. Then click the Finish button on the main Wizard window. This wizard will close. Now we can use the Property window to examine how the wizard created the DataAdapter. Don’t worry, we can run the wizard repeatedly to correct any problems or just to regenerate the Data Adapter. The wizard remembers the existing configuration and allows you to update it at any time. To get to the SQL Select statement we created in the wizard, we have to scroll down the Property window until we see the SelectCommand property. Expand it by clicking the Plus button. Your window should look like

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