BindingSources, BindingNavigators and direct navigation...

Hi there:

I dragged several fields from a Data Source to a form in the designer. It
created several TextBoxes and a BindingNavigator bound to a BindingSource
which DataSource is the DataTable containing those fields.

Now I'm able to navigate through the table to next, previous, last, ...

Here's the problem:

I want the TextBoxes show a specific row in the DataTable, say a row with
the Name field = "J Lo" (in a DataTable "People"), without having the user
navigating through several rows up until he finds this one.

How do I position the BindingSource to that specific row, if I don't know
it's relative position in the DataTable bound to the BindingSource?. The
DataTable doesn't have a CurrencyManager as the BindingSource does, and the
BindingSource doesn't have a Find method to locate specific rows.

Please help...
--

Rafael Soteldo

Rafael,

Please do not open new messages for open qeustions. Your reply was wrong.

As you don't get an answer from somebody else, than you create only
confusion with open new message threads.

And as policy in most newsgroups. People stop answering you.

Cor

"Rafael Soteldo" <RafaelSoteldo@discussions.microsoft.com> schreef in
bericht news:912041F5-77F2-4CA2-8407-84F073AF35DE@microsoft.com...
> Hi there:
>
> I dragged several fields from a Data Source to a form in the designer. It
> created several TextBoxes and a BindingNavigator bound to a BindingSource
> which DataSource is the DataTable containing those fields.
>
> Now I'm able to navigate through the table to next, previous, last, ...
>
> Here's the problem:
>
> I want the TextBoxes show a specific row in the DataTable, say a row with
> the Name field = "J Lo" (in a DataTable "People"), without having the user
> navigating through several rows up until he finds this one.
>
> How do I position the BindingSource to that specific row, if I don't know
> it's relative position in the DataTable bound to the BindingSource?. The
> DataTable doesn't have a CurrencyManager as the BindingSource does, and
> the
> BindingSource doesn't have a Find method to locate specific rows.
>
> Please help...
> --
>
> Rafael Soteldo

OK. Sorry...
--

Rafael Soteldo


"Cor Ligthert[MVP]" wrote:

>
> Rafael,
>
> Please do not open new messages for open qeustions. Your reply was wrong.
>
> As you don't get an answer from somebody else, than you create only
> confusion with open new message threads.
>
> And as policy in most newsgroups. People stop answering you.
>
> Cor
>
> "Rafael Soteldo" <RafaelSoteldo@discussions.microsoft.com> schreef in
> bericht news:912041F5-77F2-4CA2-8407-84F073AF35DE@microsoft.com...
> > Hi there:
> >
> > I dragged several fields from a Data Source to a form in the designer. It
> > created several TextBoxes and a BindingNavigator bound to a BindingSource
> > which DataSource is the DataTable containing those fields.
> >
> > Now I'm able to navigate through the table to next, previous, last, ...
> >
> > Here's the problem:
> >
> > I want the TextBoxes show a specific row in the DataTable, say a row with
> > the Name field = "J Lo" (in a DataTable "People"), without having the user
> > navigating through several rows up until he finds this one.
> >
> > How do I position the BindingSource to that specific row, if I don't know
> > it's relative position in the DataTable bound to the BindingSource?. The
> > DataTable doesn't have a CurrencyManager as the BindingSource does, and
> > the
> > BindingSource doesn't have a Find method to locate specific rows.
> >
> > Please help...
> > --
> >
> > Rafael Soteldo
>

I just thought that I needed to rephrase the question in a more clearer way...
--

Rafael Soteldo


"Cor Ligthert[MVP]" wrote:

>
> Rafael,
>
> Please do not open new messages for open qeustions. Your reply was wrong.
>
> As you don't get an answer from somebody else, than you create only
> confusion with open new message threads.
>
> And as policy in most newsgroups. People stop answering you.
>
> Cor
>
> "Rafael Soteldo" <RafaelSoteldo@discussions.microsoft.com> schreef in
> bericht news:912041F5-77F2-4CA2-8407-84F073AF35DE@microsoft.com...
> > Hi there:
> >
> > I dragged several fields from a Data Source to a form in the designer. It
> > created several TextBoxes and a BindingNavigator bound to a BindingSource
> > which DataSource is the DataTable containing those fields.
> >
> > Now I'm able to navigate through the table to next, previous, last, ...
> >
> > Here's the problem:
> >
> > I want the TextBoxes show a specific row in the DataTable, say a row with
> > the Name field = "J Lo" (in a DataTable "People"), without having the user
> > navigating through several rows up until he finds this one.
> >
> > How do I position the BindingSource to that specific row, if I don't know
> > it's relative position in the DataTable bound to the BindingSource?. The
> > DataTable doesn't have a CurrencyManager as the BindingSource does, and
> > the
> > BindingSource doesn't have a Find method to locate specific rows.
> >
> > Please help...
> > --
> >
> > Rafael Soteldo
>

Excelent!

I didn't see it. I'll try it!

Thank you
--

Rafael Soteldo


"RobinS" wrote:

> The binding source does, indeed, have a Find method. Here's an example of
> how to use it:
>
> int index = myBindingSource.Find("CompanyName", myCompanyName);
> if (index <> -1)
> myBindingSource.Position = index;
>
> RobinS.
> GoldMail.com
>
> "Rafael Soteldo" <RafaelSoteldo@discussions.microsoft.com> wrote in message
> news:912041F5-77F2-4CA2-8407-84F073AF35DE@microsoft.com...
> > Hi there:
> >
> > I dragged several fields from a Data Source to a form in the designer. It
> > created several TextBoxes and a BindingNavigator bound to a BindingSource
> > which DataSource is the DataTable containing those fields.
> >
> > Now I'm able to navigate through the table to next, previous, last, ...
> >
> > Here's the problem:
> >
> > I want the TextBoxes show a specific row in the DataTable, say a row with
> > the Name field = "J Lo" (in a DataTable "People"), without having the user
> > navigating through several rows up until he finds this one.
> >
> > How do I position the BindingSource to that specific row, if I don't know
> > it's relative position in the DataTable bound to the BindingSource?. The
> > DataTable doesn't have a CurrencyManager as the BindingSource does, and
> > the
> > BindingSource doesn't have a Find method to locate specific rows.
> >
> > Please help...
> > --
> >
> > Rafael Soteldo
>
>

Thank you RobinS,

It was there in front of my eyes, and I didn't notice. I think that's
because I'm a newbie.

Thank you very much!!
--

Rafael Soteldo


"RobinS" wrote:

> The binding source does, indeed, have a Find method. Here's an example of
> how to use it:
>
> int index = myBindingSource.Find("CompanyName", myCompanyName);
> if (index <> -1)
> myBindingSource.Position = index;
>
> RobinS.
> GoldMail.com
>
> "Rafael Soteldo" <RafaelSoteldo@discussions.microsoft.com> wrote in message
> news:912041F5-77F2-4CA2-8407-84F073AF35DE@microsoft.com...
> > Hi there:
> >
> > I dragged several fields from a Data Source to a form in the designer. It
> > created several TextBoxes and a BindingNavigator bound to a BindingSource
> > which DataSource is the DataTable containing those fields.
> >
> > Now I'm able to navigate through the table to next, previous, last, ...
> >
> > Here's the problem:
> >
> > I want the TextBoxes show a specific row in the DataTable, say a row with
> > the Name field = "J Lo" (in a DataTable "People"), without having the user
> > navigating through several rows up until he finds this one.
> >
> > How do I position the BindingSource to that specific row, if I don't know
> > it's relative position in the DataTable bound to the BindingSource?. The
> > DataTable doesn't have a CurrencyManager as the BindingSource does, and
> > the
> > BindingSource doesn't have a Find method to locate specific rows.
> >
> > Please help...
> > --
> >
> > Rafael Soteldo
>
>