INNER JOIN on a DataSet

Question

Hello, I am trying to do an INNER JOIN with 2 tables in my DataSet. One of the tables comes from an SQL source, however the second one is being populated from a file, so i cannot just do an inner join at the SELECT string level. Anyone has any idea how to do an INNER JOIN inside of a DataSet?

Answer 1

ok.. but i want to know the above script i posted giving correct output or not?

Answer 2

no
 i want in linq 

Answer 3

 resolved?

 will this not work...

 select rm.doc,rm.name,pd.address, cd.vaolum 'volumename'

 From RegistrationMaster RM inner join Partydetails pd 

 on rm.doc=pd.doc 

 inner join DocumentInfo DI 

 on rm.cdcode=DI.cdcode

 inner join CDMaster cd 

 on di.code = cd.code