I need to take data from 2 tables in the same time! help!!

<i><b>Originally posted by : Alejandro (akuzner@brinkster.net)</b></i><br /><br />Hi, I have a problem trying to display the name of an Author from the Authors tables when I take the Author Id from the books table.<br />In asp was very easy to do but in Asp.net i can't do it.<br />I will like to receive some help.<br />thanks!!

<i><b>Originally posted by : Lou E (capnlou@aol.com)</b></i><br />More information, please... how are you retreiving your data. You can do a join in the sql text you are using. That is the best way. Another alternative is adding a books table to a dataset, then adding the authors table, then adding a DataRelation on the dataset, then use the GetChildRows method of the row you are currently at in the books table. doing this requires more overhead and more explanation than i have time for. Stick with the sql join:<br /><br />Select b.*, a.* From Books b INNER JOIN Authors a ON b.AuthID = a.AuthID<br /><br /><br /><br /><br />------------<br />Alejandro at 3/29/2002 6:28:40 AM<br /><br /><br />Hi, I have a problem trying to display the name of an Author from the Authors tables when I take the Author Id from the books table.<br />In asp was very easy to do but in Asp.net i can't do it.<br />I will like to receive some help.<br />thanks!!

<i><b>Originally posted by : Jimit Patadiya (info@stpwebhosting.com)</b></i><br />It is as simple as it was with the asp. In your sql query you can refrence two tables like... "select * from authors, authorsid where authorsid.id = " & authorid...<br /><br />So it is as simple as like with Classic ASP Programming.<br /><br />Thanks,<br />Jimit Patadiya<br />http://www.stpwebhosting.com<br /><br /><br />------------<br />Lou E at 3/29/2002 11:11:09 AM<br /><br />More information, please... how are you retreiving your data. You can do a join in the sql text you are using. That is the best way. Another alternative is adding a books table to a dataset, then adding the authors table, then adding a DataRelation on the dataset, then use the GetChildRows method of the row you are currently at in the books table. doing this requires more overhead and more explanation than i have time for. Stick with the sql join:<br /><br />Select b.*, a.* From Books b INNER JOIN Authors a ON b.AuthID = a.AuthID<br /><br /><br /><br /><br />------------<br />Alejandro at 3/29/2002 6:28:40 AM<br /><br /><br />Hi, I have a problem trying to display the name of an Author from the Authors tables when I take the Author Id from the books table.<br />In asp was very easy to do but in Asp.net i can't do it.<br />I will like to receive some help.<br />thanks!!