jferg says:
sdsCompRep.SelectCommand =
"SELECT cr.compRepIdPk, cr.anuId, anu.FirstName, anu.LastName, anu.Email cr.compIdFk, c.compNm FROM compReps cr LEFT JOIN AspNetUsers anu ON cr.anuId = anu.Id LEFT JOIN comps c ON cr.CompIdFk = c.compIdPk"
;
I have cross check your code everything working fine. But you are forgot "," in your sql query.So Please replace above code with below.
C#
sdsCompRep.SelectCommand = "SELECT cr.compRepIdPk, cr.anuId, anu.FirstName, anu.LastName,anu.Email,cr.compIdFk, c.compNm FROM compReps cr LEFT JOIN AspNetUsers anu ON cr.anuId = anu.Id LEFT JOIN comps c ON cr.CompIdFk = c.compIdPk";