I have been going through the examples (Try It Out) in this book most of them I get but this chapter has been kicking me in the head. So I have decided to submit and hopefully get some help. After writing all the code for both Try It Out sections I have one that relatively works and the second one is not working at all. Let me explain my issues.


On the first Try It Out...

The Bound Data Set is suppose to show the following fields.
au_lname
au_fname
title
price

From my understanding that the code will pull the fields automatically from the pubs database as needed.

However, when I Bind the data source it pulls.
au_id
au_lname
au_fname
phone
address
city
state
zip
contract

What am I missing?

Thanks for the help! Hopefully this is clear enough if not tell me what you need from me to make this more clear.

Wrong Connection String.

What I had at first

What Fixed it