I'm going to take a guess that you're not familiar with the DataSet (which comes with a visual designer) they added back in 2005/.Net 2.0 that allows you to do just that in a similar manor.
To use it, add a new DataSet file to your solution (right click the project, go to Add, select "New Item", then click on Data from the left, and select "DataSet", you have the chance to give the .xsd file a meaningful name), then open the DataSet file, right click on it and a TableAdapter (it'll create a DataTable for you in the wizard), the first time doing this you will need to specify the connetionstring by selecting the data source. Anywho after all that is done, select the table you want to bring in, it has a query designer so you can do things like join tables, etc and once done you can attach queries to the TableAdapter, here's more info:
Working with Datasets in Visual Studio
Also note, each "query" you make on a TableAdapter you can simply call in your .Net code to do the DB interaction, including passing parameters, so you can make a CustomersTableAdapter and have one of the Fill() methods allow you to pass in a CustomerID value and viola, you have a specific row (or specific set of data).
You can make other queries for things like Inserts, Updates, & Deletes that you can call from the same TableAdapter object in your code.