Help creating data adapter

My text book reads that to create a data adapter to my sample database, all I need to do is find the connection in Server Explorer and drag the table onto my form.  Yet, I continually get the 'not gonna happen' circle indicating something's missing...what?
LVL 67
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Bob LearnedCommented:
1) .NET version?

2) It works just fine for me in 2003, if I create a simple form, and drag a table from an SQL Server database connection from the Server Explorer.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sirbountyAuthor Commented:
Hmm - come to think of it, maybe that's the problem.
I'm using 2005, but the book is geared for 2003.  I haven't installed 2003 yet.  I'll try that out and see if it changes anything.  Weird that it'd work in an earlier version, but not the latest...
Bob LearnedCommented:
I don't like many of the changes in 2005, especially the fact that you can't see SQL Server instances from the Server Explorer, without having to create a connection to each and every database :(

HTML5 and CSS3 Fundamentals

Build a website from the ground up by first learning the fundamentals of HTML5 and CSS3, the two popular programming languages used to present content online. HTML deals with fonts, colors, graphics, and hyperlinks, while CSS describes how HTML elements are to be displayed.

I could not get it to work either.  Maybe this will give us some insight.
Oh, I see.  Go to Data on the toolbar and click Show Data Sources.  You can add your data source there and then drag it to the form.
Actually, its pretty neat.  It creates a dataset, a data adapter, a binding source and a binding navagator.  If you drag your whole table over it creates a datagridview or you can drag a field over and it will create a bound textbox for you.
sirbountyAuthor Commented:
Just got it installed on this machine - will test shortly...
Bob LearnedCommented:
What is IT?

sirbountyAuthor Commented:
I have 2005 on my work laptop, but need 2003 for this...
Bob LearnedCommented:
sirbountyAuthor Commented:
Well, I'm not running SQL on this device.
I did create the connection, although there were some problems with a couple of items (not my database, so presumably specific to the index in the table I'm using).
Works 'better' at least...
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.