Merging data tables in C# is incredibly easy. If you have two tables of data pulled from the database:
In this situation our two tables have the same columns.
using System.Data; //include in your code behind so you can use data tables.
DataTable dt = Contract.GetDealContracts(pCompanyID, -1,42);
DataTable dt2 = Contract.GetDealContracts(pCompanyID, -1, 40);
You can then merge the two tables into one by simply:
dt.Merge(dt2); // table1.Merge(table2);
BOOM- two tables, now one table, with all your data.