Need To ask question From Data Table

Question

Hello,

                        I need to ask something , that I want to take values from 2 or more tables of database and need to print those values within same row  means if 2 tables are related so I need to print parent column values and child column values within same row or if 2 or more tables are not related then also i need to print values of columns of 2 tables within same row . . for that I used dataset ,datadapter, and datarow [] , like this .

 

Oleadapter = new OleDbDataAdapter(cmd1.ToString(),sConnection);

Oleadapter.Fill(ds,"table1");

DataRow[] dResult = ds.Tables["table1"].Select();

foreach(DataRow dr in dResult)

                        {
string R2 = (dr["table1column1"].Tostring();

                        }

 

Now I want to take 2^nd table values with colum within same row for printing like .

 

Console.writelin(table1column1 values , table2column1 values, table3column1 values………etc…….);

 

 

How will I do that please .Tell me the answer . as I am extracting whole query from database.  

 

Thanks