尝试

Try

var myList = objIrPortalDB.spGetDistinctUserName().ToList();
if (myList.Any())
{
   foreach (var item in myList.Where(itm=>itm != null))
   {
        dtDistinctUser.Rows.Add(item.ToString());
   }
}