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
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