Can DataAdapter take a SQL Join?

I'm looking at the comparisons between SQL queries using ADO and ADO.net(?)

ADO has the connection, command and recordset objects which are really flat in structure and easy to use. It was easy to retrieve any info from a database, especially when you had a SQL join of many table involved.:D

ADO.NET seems to provide the connection, command, dataAdapter and DataSet objects that are used to do the same thing but in a different fashion. And to me, this seems slow and confusing. :confused:

My main questions are:

1) Can you use a SQL join in the DataAdapter object, and set this set of records into a dataset (I guess you would have to name this set of data a tablename.)? Or do you have to use a dataAdapter for each table in the database and drop these tables into one Dataset, and then develop the relationship between them? Confusing.

2) Are there any methods to scroll through the DataSet easily. i.e. EOF, BOF, MoveNext, MovePrevious, MoveLast, MoveFirst.
Right now I'm scrolling through DataSet.Tables("Name").rows(index) ..indexing...but this sucks!

3) Are they developing VB.net to feel more like the C++ and Java dot notation and structures?

I have a lot to learn!

I hope you can answer these questions. I'm an Engineer who uses Visual Basic as a tool..I'm not a Computer Programmer with a degree! I hate learning new crap..but I know I need to!!;)

1) Yes you can use Joins AND you can create relationships as well. Just depends on what you need

2) For Each DataRow in DataTable style loop

3) Pretty much.

I think I found some good information about DataAdapters and DataSets:

http://www.informit.com/isapi/produc...tent/index.asp

This guy knows his stuff.:rolleyes:

I guess the main thing to think about is that DataSet work as a new idea to disconnected recordsets and is full-featured relational database in its own right.

This sounds really awesome!!!:)
Better than I'm expecting, so I must get moving on it!:rolleyes:

yeah they are definatly great. It takes some getting used to if you have used classic ADO, but once you get started, you will be glad you did. Even creating the Relationship as you mentioned is dirt simple.