I have a form that contains a dataviewgrid that can contain a large number of rows. The sort on the dataview is preset and can also be modified by a pre-defined set of sorts in a dropdown.
The thing I would like to be able to incorporate into this form is a text box where the user can enter a value associated with the FIRST FIELD in the sort order. At the same time if the sort order contains multiple fields, can I perform a find as I've included common code below to locate the first occurance of the first field in the sort? I specifically need to be able to move the pointer to this row (glCurrentRow) so that a double-click will allow me to get an ID field hidden in the dataviewgrid.
Dim i As Int64 = 0, vals(1) As Object
vals(0) = Convert.ToInt64(txtIndex.Text)
vals(1) = glInvoiceAssessment
i = dvGlobalDuesInvoices.Find(vals)
If i >= 0 Then
glCurrentInvoiceAssessmentEntryRow = i
glCurrentRow = i
glCurrentInvoiceAssessmentEntryRow = 0
glCurrentRow = 0