Direct navigation to specific rows in a DataSource...

  • Thread starter Thread starter Rafael Soteldo
  • Start date Start date
R

Rafael Soteldo

Hi there:

I need to get the position of a given Row to navigate directly to it, in a
form that has a BindingNavigator and several TextBoxes showing each rows
details...

I dragged the fields from the Data Sources window to the form in the
designer, which created the BindingNavigator attached to a BindingSource.

As far as I know, the BindingSource lets you move to the first, next, to a
position, previous and last row of a DataTable, so, what if I need to
navigate directly to a row that has a specific value in a field (for
instance, "Carl" in the field "Name" in the DataTable "People"). I suppose I
should get the row position within the DataTable attached to the
BindingSource, and then set the BindingSource.Position to that position.

But how ca I do that?, the DataTable doesn't expose a property that shows
the relative position of each row in the table.

Moreover, what if the DataSource is a DataView with filters set, how do I
get the position of that given row within this DataView?

Please, need help...

Thanks in advance...,

Rafael Soteldo
 
Hi Cor:

The CurrencyManager holds the position of the current row in the
BindingSource, but I want to navigate directly to a specific row whose
relative position in the DataTable is unknown. The DataTable doesn't expose a
CurrencyManager.

I guess there must be another way...
 
Rafael said:
I'll try it...

thanks
Click to expand...

I'd use the "select" method of the DataTable connected to the
DataSource. All the details in the SDK documentation.

HTH
Hertha
 
Hi Hertha:

Whenever I use Select, it doesn't set the position of the BindingSources
attached to the DataTable.

The question is: How do I position a BindingSource (attached to a DataTable)
to a row which position in the DataTable is unknown.

Select returns a Row[], if the row I'm looking fo is unique, the array will
have only one row, but, what's it's relative position in the table?

The DataTable itself doen't have a CurrencyManager to help us know the
relative position of each row.

I still don't know what to do here...

Why am I asking this:

I dragged several fields from the DataSource window to my form. It created
several textboxes, a BindingNavigator and a BindingSource which will be the
intermidiate layer between the DataTable and the mentioned controls.

The only way a user has to look for a row in the DataTable with this
interface is to navigate through several rows until he (she) finds it.

I want to give the user the ability to also specify a field value (for
example "J Lo" in a DataTable People), to go directly to...
 
Back
Top