I do the following...
var results = from rowOne in dtOne.AsEnumerable()
join rowTwo in dtTwo.AsEnumerable() on rowOne.Field<int>("ruleId") equals rowTwo.Field<int>("ruleid")
where rowTwo.Field<int>("hotelid") == 3
select new { hotelid = rowTwo["hotelid"], des ...
Go to the complete details ...