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.OleDbDataAdapter

sql = "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 string

daFindings = New OleDb.OleDbDataAdapter(sql, con)

' fill the dataset with data

daFindings.Fill(dsFindings, "tbl_Findings")

If this is possible, how would I bind it? I tried:
NDataNavigator1.DataNavigatorElement.DataSource = dsFindings

But that did nothing....

Thanks!

Hi Garry,

You can find example that demonstrates how to use NDataNavigator in the examples application that is provided with the controls.

Here is a code snipped that shows how you have to attach to ButtonClick event:

Private Sub NDataNavigator1_ButtonClick(ByVal sender As Object, ByVal e As System.EventArgs) Handles NDataNavigator1.DataNavigatorElement.ButtonClick

End Sub

To get the id of the pressed button you can do the following:

Dim buttonId As Integer = TryCast(sender, NRepeatButtonElement).PartStateInfo.PartId

I hope now is more clear.

Regards,

Angel.