• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 225
  • Last Modified:

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?
0
sirbounty
Asked:
sirbounty
  • 4
  • 4
  • 3
2 Solutions
 
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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 4
  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now