Hello I have written following LINQ query... I want to add this result into DataTable
var select =(from objmemberinfo in db.tbl_MemberTransactions
where objmemberinfo.MemberId == dic.Key
select new { objmemberinfo.MemberId, MemberName = objmemberinfo.tbl_MemberMaster.MemberFirstName + " " + objmemberinfo.tbl_MemberMaster.MemberLastName, objmemberinfo.SponceID, objmemberinfo.PlacemMentID, objmemberinfo.tbl_MemberMaster.tbl_ProductTbl.productName, ActivationDate = (objmemberinfo.tbl_MemberMaster.Status == true ? string.Format("{0:dd/MM/yyyy}", objmemberinfo.tbl_MemberMaster.JoiningDate) : "NOT ACTIVE"), Position = (objmemberinfo.Position == "0" ? "Left" : "Right"), Status = (objmemberinfo.tbl_MemberMaster.Status == false ? "NOT ACTIVE" : "ACTIVE") }).Single();
Please help me for this solution...
What I have tried:
var select =(from objmemberinfo in db.tbl_MemberTransactions
where objmemberinfo.MemberId == dic.Key
select new { objmemberinfo.MemberId, MemberName = objmemberinfo.tbl_MemberMaster.MemberFirstName + " " + objmemberinfo.tbl_MemberMaster.MemberLastName, objmemberinfo.SponceID, objmemberinfo.PlacemMentID, objmemberinfo.tbl_MemberMaster.tbl_ProductTbl.productName, ActivationDate = (objmemberinfo.tbl_MemberMaster.Status == true ? string.Format("{0:dd/MM/yyyy}", objmemberinfo.tbl_MemberMaster.JoiningDate) : "NOT ACTIVE"), Position = (objmemberinfo.Position == "0" ? "Left" : "Right"), Status = (objmemberinfo.tbl_MemberMaster.Status == false ? "NOT ACTIVE" : "ACTIVE") }).Single();