Tablemappings and join?

  • Thread starter Thread starter Dan Keeley
  • Start date Start date
D

Dan Keeley

Hi,

I have this sql command:

Select recommendation, timescale from audits, auditItems where
AuditItems.ParentAuditID = Audts.AuditID and Audits.SupplierId = '" &
ComboItem.Value & "'"



So what do i set tablemappings to?



I usually do this:

myDataAdapter.TableMappings.Add("Table", "Audititems")



but that doesnt work... Any ideas?



Thanks,

Dan
 
or even ( below )

Both of these seem to compile and work, but then give a "No value given for
one or more required paramaters" as soon as i try to fill the dataset / do
the mappings.

Select SuppliersID, recommendation, timescale from audits INNER JOIN
auditItems ON Audits.AuditID = auditItems.ParentAuditID
 
Back
Top