how can u merge two LINQ Result in One result in Grid view ?

use Inner join, left join, right join, union
in your sql statement

or in linq you can use "join"

see example below

var QueryResult = from p in Person
                  join c Company on p.ID equals c.PersonID
                  where c.Country == "Philippines"
                  select new { c.Name, p.Name };

Click here for more information

Vote or Accept solution
If this will help you
thanks