Direct navigation to specific rows in a DataSource...

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
Wed Apr 23 22:43:03 CDT 2008


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

RafaelSoteldo
Thu Apr 24 11:34:02 CDT 2008

Thanks for answering!

I'll study it...
--

Rafael Soteldo


"Cor Ligthert[MVP]" wrote:

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

RafaelSoteldo
Fri Apr 25 01:00:00 CDT 2008

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 Soteldo


"Cor Ligthert[MVP]" wrote:

>
> 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...
> > 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
Fri Apr 25 11:53:42 CDT 2008

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" <RafaelSoteldo@discussions.microsoft.com> schreef in
bericht news:18C731C5-F481-437D-A342-87A955A0A4C8@microsoft.com...
> 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 Soteldo
>
>
> "Cor Ligthert[MVP]" wrote:
>
>>
>> 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...
>> > 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
>>
>>

RafaelSoteldo
Fri Apr 25 13:46:05 CDT 2008

I'll try it...

thanks
--

Rafael Soteldo


"Cor Ligthert[MVP]" wrote:

> 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" <RafaelSoteldo@discussions.microsoft.com> schreef in
> bericht news:18C731C5-F481-437D-A342-87A955A0A4C8@microsoft.com...
> > 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 Soteldo
> >
> >
> > "Cor Ligthert[MVP]" wrote:
> >
> >>
> >> 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...
> >> > 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
> >>
> >>
>
>

Hertha
Sat Apr 26 14:53:56 CDT 2008

Rafael Soteldo schrieb:
> 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

RafaelSoteldo
Sat Apr 26 19:24:01 CDT 2008

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

Rafael Soteldo


"Hertha Steck" wrote:

> Rafael Soteldo schrieb:
> > 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
>