Join Tables without DataRelation

[Steve Bishop]

I am use to working with only single tables with my command object. Now
I have 2 tables that need a 1 to 1 relationship. Is it possible to inner
join 2 tables in my SQL statement before thowing the data into the
DataSet?? I'm trying to avoid the DataRelation object.

Also, all the examples I have show using the data grid and no form
fields to display data. I would like to read some of the records into
Web Server controls like text boxes. Example appreciated. Thanks.
Steve

 

[Ignacio Machin \( .NET/ C# MVP \)]

Hi Steve,

Are you going to do so in the SQL layer?

IF so you can do something like SELECT TABLE1.* , TABLE2.* FROM TABLE1,
TABLE2 WHERE table1.ID = table2.ID


Cheers,

 

[William Ryan eMVP]

Out of curiosity, why don't you want to use a DataRelation, they rock?

 

[Steve Bishop]

I would like to learn more about it. Unfortunately, some of my
datasource tables dont have a primary key or any constraints assigned on
there way out of their proprietary odbc driver. My SQL inner joins are
working ok for now.

Would like to explore the DataRelation object more when we port some of
these tables to SQL Server.

Thanks.