'Incremental Search' of data base or "Wheres the 'Seek' method

[Terry]

Hi,
I am both new to .Net (coming from VB6 and DAO) and to this news group. I
am trying to convert some code from VB6 that uses a "record set" to help the
user locate a specific record.
As the user types into a text box, the grid position changes.
example:

rs.index = "CompanyName"
..
..
..
Private Sub txtCompanyName_Changed()
rs .seek ">=", txtCompanyName.Text
..
..
..
I not only can't find a "seek" function for a table in a dataset, I can't
find any mention of an index for a table in a dataset! Am I missing
something? I hope the solution is not that I have to issue a new SELECT
with a sort by clause and then a loop with a move next statement!

Any help would be greatly appreciated!
Terry

[Ralph]

"Terry" <Te********@hotmail.com> wrote in message
news:uR*************@TK2MSFTNGP02.phx.gbl...

Hi,
I am both new to .Net (coming from VB6 and DAO) and to this news group. I
am trying to convert some code from VB6 that uses a "record set" to help the user locate a specific record.
As the user types into a text box, the grid position changes.
example:

rs.index = "CompanyName"
.
.
.
Private Sub txtCompanyName_Changed()
rs .seek ">=", txtCompanyName.Text
.
.
.
I not only can't find a "seek" function for a table in a dataset, I can't
find any mention of an index for a table in a dataset! Am I missing
something? I hope the solution is not that I have to issue a new SELECT
with a sort by clause and then a loop with a move next statement!

Any help would be greatly appreciated!
Terry

--
<response type="generic" language="VB.Net">
This newsgroup is for users of Visual Basic version 6.0
and earlier and not the misleadingly named VB.Net
or VB 200x. Solutions, and often even the questions,
for one platform will be meaningless in the other.
When VB.Net was released Microsoft created new newsgroups
devoted to the new platform so that neither group of
developers need wade through the clutter of unrelated
topics. Look for newsgroups with the words "dotnet",
"framework", or "vsnet" in their name.

For the news.microsoft.com news server try these:

news://msnews.microsoft.com/
microsoft.public.dotnet.languages.vb.upgrade
microsoft.public.dotnet.languages.vb.controls
microsoft.public.dotnet.languages.vb.data
microsoft.public.dotnet.framework.adonet
microsoft.public.dotnet.framework.windowsforms.con trols
microsoft.public.dotnet.framework.windowsforms.dat abinding
</response>

[Cor Ligthert [MVP]]

Terry,

If you are used to recordset, than don't try to compare them with datasets.
The datatable is the most neares.

A datatable hold datacolumns and datarows.

The datacolumns describes the items in a datarow
Every datarow has data items.

And than we have very much methods where ADO has one
There is the
DataView rowfilter
DataView find
DataTAble select
DataRowCollection find
And more

http://msdn2.microsoft.com/en-us/lib...tion.find.aspx

I think that the one above meets the solution to your current problem the
most.

I hope this helps,

Cpr

"Terry" <Te********@hotmail.com> schreef in bericht
news:uR*************@TK2MSFTNGP02.phx.gbl...

Hi,
I am both new to .Net (coming from VB6 and DAO) and to this news group. I
am trying to convert some code from VB6 that uses a "record set" to help
the user locate a specific record.
As the user types into a text box, the grid position changes.
example:

rs.index = "CompanyName"
.
.
.
Private Sub txtCompanyName_Changed()
rs .seek ">=", txtCompanyName.Text
.
.
.
I not only can't find a "seek" function for a table in a dataset, I can't
find any mention of an index for a table in a dataset! Am I missing
something? I hope the solution is not that I have to issue a new SELECT
with a sort by clause and then a loop with a move next statement!

Any help would be greatly appreciated!
Terry

[Terry]

Hi,
I do not wish to "filter " the results, I want to position the current
row. The 'find' method requires that I already know the value being
sought, which obviously is not the case. For example,
when the
user type 'M' in the text box, I want the top row of the DataView to be the
first company name that starts with 'M' and when he then types a 'i' I want
the top row to be the first entry that starts with 'Mi' etc. If no such
entry exists, the DataView would still be positioned at the first record
starting with 'M' as opposed to having an empty DataView, which would be the
result of setting a filter for the first 2 characters of company name being
"Mi".
So, I ask again, how do I quickly "position" the datagridview?
"Cor Ligthert [MVP]" <no************@planet.nl> wrote in message
news:O$**************@TK2MSFTNGP04.phx.gbl...

Terry,

If you are used to recordset, than don't try to compare them with
datasets. The datatable is the most neares.

A datatable hold datacolumns and datarows.

The datacolumns describes the items in a datarow
Every datarow has data items.

And than we have very much methods where ADO has one
There is the
DataView rowfilter
DataView find
DataTAble select
DataRowCollection find
And more

http://msdn2.microsoft.com/en-us/lib...tion.find.aspx

I think that the one above meets the solution to your current problem the
most.

I hope this helps,

Cpr

"Terry" <Te********@hotmail.com> schreef in bericht
news:uR*************@TK2MSFTNGP02.phx.gbl...

Hi,
I am both new to .Net (coming from VB6 and DAO) and to this news group.
I am trying to convert some code from VB6 that uses a "record set" to
help the user locate a specific record.
As the user types into a text box, the grid position changes.
example:

rs.index = "CompanyName"
.
.
.
Private Sub txtCompanyName_Changed()
rs .seek ">=", txtCompanyName.Text
.
.
.
I not only can't find a "seek" function for a table in a dataset, I can't
find any mention of an index for a table in a dataset! Am I missing
something? I hope the solution is not that I have to issue a new SELECT
with a sort by clause and then a loop with a move next statement!

Any help would be greatly appreciated!
Terry

[Cor Ligthert [MVP]]

Terry,

Sorry but "postition" in Net means the place that a row has inside its
collection, which is showed or whatever.

"Sort" means to set them in a special sequence,

I cannot change the used terminology

Therefore do you need a position or do you want to show the rows in a
special sorted way.

The DataGridView has no position but has a rowindex.

Cor

"Terry" <Te********@hotmail.com> schreef in bericht
news:uP**************@TK2MSFTNGP03.phx.gbl...

Hi,
I do not wish to "filter " the results, I want to position the current
row. The 'find' method requires that I already know the value being
sought, which obviously is not the case. For example,
when the
user type 'M' in the text box, I want the top row of the DataView to be
the first company name that starts with 'M' and when he then types a 'i' I
want the top row to be the first entry that starts with 'Mi' etc. If no
such entry exists, the DataView would still be positioned at the first
record starting with 'M' as opposed to having an empty DataView, which
would be the result of setting a filter for the first 2 characters of
company name being "Mi".
So, I ask again, how do I quickly "position" the datagridview?
"Cor Ligthert [MVP]" <no************@planet.nl> wrote in message
news:O$**************@TK2MSFTNGP04.phx.gbl...

Terry,

If you are used to recordset, than don't try to compare them with
datasets. The datatable is the most neares.

A datatable hold datacolumns and datarows.

The datacolumns describes the items in a datarow
Every datarow has data items.

And than we have very much methods where ADO has one
There is the
DataView rowfilter
DataView find
DataTAble select
DataRowCollection find
And more

http://msdn2.microsoft.com/en-us/lib...tion.find.aspx

I think that the one above meets the solution to your current problem the
most.

I hope this helps,

Cpr

"Terry" <Te********@hotmail.com> schreef in bericht
news:uR*************@TK2MSFTNGP02.phx.gbl...

Hi,
I am both new to .Net (coming from VB6 and DAO) and to this news group.
I am trying to convert some code from VB6 that uses a "record set" to
help the user locate a specific record.
As the user types into a text box, the grid position changes.
example:

rs.index = "CompanyName"
.
.
.
Private Sub txtCompanyName_Changed()
rs .seek ">=", txtCompanyName.Text
.
.
.
I not only can't find a "seek" function for a table in a dataset, I
can't find any mention of an index for a table in a dataset! Am I
missing something? I hope the solution is not that I have to issue a
new SELECT with a sort by clause and then a loop with a move next
statement!

Any help would be greatly appreciated!
Terry