I am new to
SharePoint. I am developing a
web-part in that I am trying to join two list.
I have a same
web-part in that lists were join using
But it takes more time to fetch the data. So I am trying to convert it into
I want to know that is there any way to achieve
CAML.Join between two lists without any lookup columns.???
Or Is there any way to convert
ResultSet into direct
DataTable. I mean, to data from the
LINQ query in
Title | Name ------------ SA | Sales HR | HumanResource FI | Finance
Title | Name | Department -------------------------- Mr | ABC | Sales Mr | XYZ | Finance Mr | MNO | Sales Mr | PQR | HumanResource
In the above lists Employee list has the Department Column which is the lookup field from department. I want to get the Employee data when Department Column is not the LOOKUP Field And also using
Any suggestion will be appreciated.
Thank you in advance!!!