I'm anxiously awaiting replies to this message. :o) In the meantime, I found some handy links recently that help explain ADO.NET that you may want to read:

http://www.codeproject.com/dotnet/ADONETOOP.asp
http://www.dnjonline.com/article.aspx?ID=iss22_essentials
http://www.csharp-station.com/Tutorials/AdoDotNet/Lesson01.aspx
http://articles.techrepublic.com.com/5100-3513_11-6095080.html


>I’m looking for a better understanding of just where the data I’m working against resides for any given action.
>
>If I create a tableadapter and use the fill method, my understanding is that I create an array of rows of data in memory correct?
>
>If I then want to see a specific piece of that data, right now I am using what looks like a reference to my dataset.rows[x][y] ?
>
>Isn’t there a way to access an item in the tableadapter’s data by referring to the column name? And is this just another way to access the same data in memory?
>
>What data am I accessing when I use a dataset.tablename.select(“last like ‘A*’”) ? Is this going back to the original data just like the fill does or is this just accessing the data in memory (the array)?
>
>Why can’t I do a command like dataset.tablename.select(“year(transdate)=2007”) ? This is a legal sql query but the compiler does not allow it?
>
>Thanks to all who reply.