dataview find?

[oscar]

i've created a search function, using vc#, and i'm using the dataview.find()
method to get the index of the found record. the problem is that there are
many similar names. it always returns the same index, but it can be any one
of the items. as an example, if i type in the work "bolt" it will return the
index 1201, the first "bolt" is at 1120 and the last one is at 1294. it is
for a point of sale program and i have no control over the part titles. it
sorts them in alpha order and i need it to point to the first "bolt" in the
dataview (which is bound to the datagrid). i've also tried using the
dataview.findrows() method but can not find a way to get the index from the
rows. if i could get the index from the findrows() then i could just point
the CM to it. is there anyway to get that index?

thanx in advance.

[Curt_C [MVP]]

try .Sort first

--
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"oscar" <os***@discussions.microsoft.com> wrote in message
news:DC**********************************@microsof t.com...

i've created a search function, using vc#, and i'm using the
dataview.find()
method to get the index of the found record. the problem is that there
are
many similar names. it always returns the same index, but it can be any
one
of the items. as an example, if i type in the work "bolt" it will return
the
index 1201, the first "bolt" is at 1120 and the last one is at 1294. it
is
for a point of sale program and i have no control over the part titles.
it
sorts them in alpha order and i need it to point to the first "bolt" in
the
dataview (which is bound to the datagrid). i've also tried using the
dataview.findrows() method but can not find a way to get the index from
the
rows. if i could get the index from the findrows() then i could just
point
the CM to it. is there anyway to get that index?

thanx in advance.

[oscar]

have to .Sort before .find or .findrows will work. it sorts them in the
right alpha order, but just does not go to the first instance of my search
criteria.

"Curt_C [MVP]" wrote:

try .Sort first

--
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"oscar" <os***@discussions.microsoft.com> wrote in message
news:DC**********************************@microsof t.com...

i've created a search function, using vc#, and i'm using the
dataview.find()
method to get the index of the found record. the problem is that there
are
many similar names. it always returns the same index, but it can be any
one
of the items. as an example, if i type in the work "bolt" it will return
the
index 1201, the first "bolt" is at 1120 and the last one is at 1294. it
is
for a point of sale program and i have no control over the part titles.
it
sorts them in alpha order and i need it to point to the first "bolt" in
the
dataview (which is bound to the datagrid). i've also tried using the
dataview.findrows() method but can not find a way to get the index from
the
rows. if i could get the index from the findrows() then i could just
point
the CM to it. is there anyway to get that index?

thanx in advance.

[vMike]

"oscar" <os***@discussions.microsoft.com> wrote in message
news:DC**********************************@microsof t.com...

i've created a search function, using vc#, and i'm using the dataview.find() method to get the index of the found record. the problem is that there are many similar names. it always returns the same index, but it can be any one of the items. as an example, if i type in the work "bolt" it will return the index 1201, the first "bolt" is at 1120 and the last one is at 1294. it is for a point of sale program and i have no control over the part titles. it sorts them in alpha order and i need it to point to the first "bolt" in the dataview (which is bound to the datagrid). i've also tried using the
dataview.findrows() method but can not find a way to get the index from the rows. if i could get the index from the findrows() then i could just point the CM to it. is there anyway to get that index?

thanx in advance.

have you tried something like dataview.rowfilter = "PartsName = '*'bolt'*"
It should return all rows with bolt and then you can .sort it and get the
first record? If the list doesn't sort properly you may need to add a column
in code to the datatable which has information needed to sort the table.