all groups > dotnet ado.net > april 2008 >
You're in the

dotnet ado.net

group:

Direct navigation to specific rows in a DataSource...


Direct navigation to specific rows in a DataSource... Rafael Soteldo
4/23/2008 5:04:00 AM
dotnet ado.net:
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...,

Re: Direct navigation to specific rows in a DataSource... Cor Ligthert[MVP]
4/24/2008 5:43:03 AM

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" <RafaelSoteldo@discussions.microsoft.com> schreef in
bericht news:920F4FCF-ECB4-46C3-9F1D-971BC45E84D3@microsoft.com...
[quoted text, click to view]
Re: Direct navigation to specific rows in a DataSource... Rafael Soteldo
4/24/2008 9:34:02 AM
Thanks for answering!

I'll study it...
--

Rafael Soteldo


[quoted text, click to view]
AddThis Social Bookmark Button