Accessing two OleDb Tables at once?

DakaBoaz

So I got the SQL basic: "SELECT A.* , B.* Where A.ID = B.ID;" Now I need to access the data within the OleDbReader Object (it's an access database). I can get everything that is absolute (i.e. Client Address comes up as "address" and is the only column named so), but cannot access any duplicates (i.e A.Name - a clients name and B.Name - the sales man name)... I put it on the Reader[ "A.Name" ] , but it exclaims an error! HELP! How do I access the data withing the reader object (or even better, the repeater object that is binded to it)? Thanks, Boaz

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

madinewala22y ago
Boaz, DataReader can only be used for forward reading of data, but not accessing the data within it. Inorder to access it, you must replace your datareader with a dataset. For your requirement, try using the DataSet to access the data from both the tables i.e A.Name and B.Name. Within your dataset, you could then get the data either using the column name or using the ID. HTH, irfan
0
DakaBoaz22y ago
Right, but I did in the program - I got the SQL righjt, trust me (I do get returns on the columns that dont have name conflicts)... But thank you for noticing...
0
zseml22y ago
You aren't adding a "FROM" clause in that statement.
0