Joints, DataBases and Accessing 2 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

4 Replies

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

Adam Erstelle22y ago
To ensure you are knowing the index value of a column, you will have to specify each column instead of using the * eg: Select A.Name,A.Address,A.Street,B.Name as SalesManName,b.Country from .......etc then when you are getting the values from your dataset, use "Name","Address","Street","SalesManName","Country" or whatever values you have selected
S_Kiryazov22y ago
I'm not sure that there is a different one. I've always been using alias.
DakaBoaz22y ago
How do I know the Index Value? Trail and error? Just start counting and hope for the best? ... Surly there is some way the Reader object can get the sql "Table1.A" column (and distinguish it from "Table2.A") which is in clear text. no? (p.s - I'll try the index value, it is a good solution, just like the "Table.A as T1A" sql solution... I am just sure there is a different one...)
kvreddy7222y ago
try index value ex. Reader[2].ToSrring();