give a first try on join datatable. if it is not doing as expected then we go ahead with LINQ
have a look here as well