Pantagruel, heya! Doesn't any of these queries share any columns? Say, Query1 returns columns A, B and C, while Query2 returns B, C, D and E? If that's the case, the Merge method from a System.Data.DataTable object should do the trick.
Hope it helps! - Leon On Feb 27, 6:21 am, pantagruel <[email protected]> wrote: (...) > I need to execute the queries and then loop through the rows of each > query and then combine these results, the final combination is written > to a text file matching a particular archiving format. > The queries do not return the same nunber of columns or rows. > If query returns two rows 7 columns, query 2 returns 0 rows but has 4 > possible columns (if it did return anything), and query 3 returns 3 > rows 2 columns then the final output should be > > 3 rows 13 columns with the empty columns in the database replaced by > particular characters. (...)
