Is it possible to use a dataset as the bind for the datanavigator? I have: (This is for a microsoft access query)
Dim
dsFindings As New DataSet
Dim daFindings As OleDb.OleDbDataAdaptersql = "select tbl_findings.id, tbl_findings.location, tbl_findings.RAC, tbl_findings.checklist_number, tbl_findings.checklist, tbl_findings.corrective_actions,tbl_findings.reference,tbl_findings.notes, tbl_findings.discrepnum from tbl_findings where opfac='" & curOpfac & "' and visitdate=#" & curVisitDate & "# and visittype='" & curVisitType & "' order by tbl_findings.discrepnum"
' run the sql statement against the connection stringdaFindings =
New OleDb.OleDbDataAdapter(sql, con)' fill the dataset with datadaFindings.Fill(dsFindings,
"tbl_Findings")
If this is possible, how would I bind it? I tried:
NDataNavigator1.DataNavigatorElement.DataSource = dsFindingsBut that did nothing....
Thanks!