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 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["Execution"].Select();
foreach(DataRow dr in dResult)
{
}
Now I want to take 2nd table values within same row for printing like .
Console.writelin(table1values , table2values, table3values………etc…….);
How will I do that please .Tell me the answer . as I am extracting whole query from database .
Thanks
pedaammuluPosted Aug 5, 2006, 5:04 AM
mateen ashrafPosted Aug 3, 2006, 6:07 PM
http://www.samspublishing.com/articles/article.asp?p=25763&rl=1
sitaramserthPosted Aug 3, 2006, 6:31 AM
Dear Sir,
Your question is Jayaj.
You should take 2 different Adapters to do so.
Take Care.
With Regards,
Muhammad AsifPosted Jul 25, 2006, 9:16 AM