LINQ result to data table ?

See more:

LINQ

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();