DataNavigator Question


Author
Message
Gary Smith
Gary Smith
Forum Member (39 reputation)Forum Member (39 reputation)Forum Member (39 reputation)Forum Member (39 reputation)Forum Member (39 reputation)Forum Member (39 reputation)Forum Member (39 reputation)Forum Member (39 reputation)Forum Member (39 reputation)
Group: Forum Members
Posts: 39, Visits: 1

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!

 


Reply
Gary Smith
Gary Smith
Forum Member (39 reputation)Forum Member (39 reputation)Forum Member (39 reputation)Forum Member (39 reputation)Forum Member (39 reputation)Forum Member (39 reputation)Forum Member (39 reputation)Forum Member (39 reputation)Forum Member (39 reputation)
Group: Forum Members
Posts: 39, Visits: 1

Thanks for the example Angel. From this I can see how it works to obtain the id of the button pressed, however for clarification - as for samples, I could find none that describe how to use the NDataNavigator control, The example provided basically shows how to assign a datasource. There is also no documentation on this control in the online, or supplied docs... oversight? 

Also (more importantly) I am seeing this error now since adding the NDataNavigator_ButtonClick event....

Warning 1 Unable to cast object of type 'Nevron.UI.NDataNavigatorElement' to type 'System.ComponentModel.IComponent'.  0 0 

Suggestions?

 


GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search