Direct navigation to specific rows in a DataSource...

[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

 

[Cor Ligthert[MVP]]

Rafael,

You are using so many techniques over each other that I don't know how to
answer this. However this class manages your positions in a table.

http://msdn2.microsoft.com/en-us/library/system.windows.forms.currencymanager.aspx

(It has nothing to do with currencies in the way of money as sometimes is
thought)

Cor

 

[Rafael Soteldo]

Thanks for answering!

I'll study it...

 

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

 

[Cor Ligthert[MVP]]

Rafael,

The currencymanager exist much longer than the bindingsource, it is there as
long as there is Net.

Two samples.
http://www.vb-tips.com/DataGridRowChange.aspx

http://www.vb-tips.com/DataGridRowCount.aspx

Cor

 

[Rafael Soteldo]

I'll try it...

thanks
--

Rafael Soteldo

Rafael,

The currencymanager exist much longer than the bindingsource, it is there as
long as there is Net.

Two samples.
http://www.vb-tips.com/DataGridRowChange.aspx

http://www.vb-tips.com/DataGridRowCount.aspx

Cor

 

[Hertha Steck]

I'll try it...

thanks

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

HTH
Hertha

 

[Rafael Soteldo]

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