>>- sqlclient is for SQL server and is faster than OLEDB
>>- the datareader control is read-only and much faster than the dataAdapter which is read/write
>>- dataAdapter allows you to preview the data to be pulled back
>>- remember to call the Fill() method to get the databack!
>
>
>Just a few comments about these items. I have finished and submitted the 2nd part of the ADO .NET series I wrote for Code Magazine. I have concluded that DataAdapter is a useless beast and further, does nothing that you cannot do better yourself. The Fill, and data modification methods of the dataadpater are too black box. In the article, I show how you can build your own data adapter that does the work of fetching data and transferring it to a dataset. I also use the classes in the sqlclient namespace as well.

That should be an interesting read.