private void BindGrid()
{
var memberYearDetail = (from MY in Common.dataContext.MemberYears
join PM in Common.dataContext.ProfileMasters
on MY.ProfileId equals PM.ProfileId
join AD in Common.dataContext.AddressDetails
on PM.ProfileId equals AD.LinkedSourceId
join GM in Common.dataContext.GeographyMasters
on AD.GeographicId equals GM.GeographicId
select new
{
MY.ProfileId,
GM.GeographicName,
MemberName = PM.FirstName + " " + PM.MiddleName + " " + PM.LastName
}).Distinct();
grdMemberYear.DataSource = memberYearDetail;
grdMemberYear.DataBind();
}
No comments:
Post a Comment