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
No credit card required