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.