DakaBoaz

DakaBoaz

  • NA
  • 6
  • 0

Joints, DataBases and Accessing 2 tables at once

Sep 10 2004 3:52 PM
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

Answers (4)