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
sirbountyAsked:
Who is Participating?
 
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.

Bob
0
 
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...
0
 
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 :(

Bob
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
maralansCommented:
I could not get it to work either.  Maybe this will give us some insight.

http://blogs.msdn.com/vbteam/archive/2004/08/27/221584.aspx
0
 
maralansCommented:
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.
0
 
maralansCommented:
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.
0
 
sirbountyAuthor Commented:
Just got it installed on this machine - will test shortly...
0
 
Bob LearnedCommented:
What is IT?

Bob
0
 
sirbountyAuthor Commented:
2003.
I have 2005 on my work laptop, but need 2003 for this...
0
 
Bob LearnedCommented:
:)
0
 
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...
Thanx.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.