BraveHeart,
What I normally do is add a new Component (Project - Add Component) to my
project.
Using the visual designer of the Component you can then drag the Connection,
Command, and DataAdapter objects that I want to it from the Toolbox.
Alternatively you can drag & drop items from the Server Explorer. You can
set properties of these with the properties window.
Then from the Code Behind I add any methods that I want exposed via the
Component.
Hope this helps
Jay