473,397 Members | 1,961 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,397 software developers and data experts.

search record in a table

HS1
Hello

To present (and manipulate) data in a table, I use an DataGrid and a DataSet
"ds"

DataGrid1.DataSource = ds

However, to search a record in this DataGrid, I have to use DataView "dv"

DataGrid1.DataSource = dv
int = dv.Find (.......)

Can I use only one of them for both searching and manipulating data for a
table

Thank you very much
Best regards
S.Hoa
Nov 21 '05 #1
3 1234
S. Hoa,

I think that the most easiest way is to get your row is to create another
(extra) dataview.

A dataview is just a filter on your table.

There is no dataview find, because that belongs to the datarowcollection.

Use on that other dataview the rowfilter what is very easy to use. Possible
is as well the datatable.select. Beneath in another message I have send the
links of explanations for all those to somebody else.

http://groups.google.com/groups?selm...tngp13.phx.gbl

I hope this helps?

Cor

"HS1" <so*@slingshot.co.nz>

To present (and manipulate) data in a table, I use an DataGrid and a
DataSet
"ds"

DataGrid1.DataSource = ds

However, to search a record in this DataGrid, I have to use DataView "dv"

DataGrid1.DataSource = dv
int = dv.Find (.......)

Can I use only one of them for both searching and manipulating data for a
table

Thank you very much
Best regards
S.Hoa

Nov 21 '05 #2
Cor, I think you are mistaken. A dataview has a find method, it works on the
sorted column(s).
Frank

"Cor Ligthert" <no************@planet.nl> wrote in message
news:uN*************@TK2MSFTNGP11.phx.gbl...
S. Hoa,

I think that the most easiest way is to get your row is to create another
(extra) dataview.

A dataview is just a filter on your table.

There is no dataview find, because that belongs to the datarowcollection.

Use on that other dataview the rowfilter what is very easy to use. Possible is as well the datatable.select. Beneath in another message I have send the links of explanations for all those to somebody else.

http://groups.google.com/groups?selm...tngp13.phx.gbl
I hope this helps?

Cor

"HS1" <so*@slingshot.co.nz>

To present (and manipulate) data in a table, I use an DataGrid and a
DataSet
"ds"

DataGrid1.DataSource = ds

However, to search a record in this DataGrid, I have to use DataView "dv"
DataGrid1.DataSource = dv
int = dv.Find (.......)

Can I use only one of them for both searching and manipulating data for a table

Thank you very much
Best regards
S.Hoa


Nov 21 '05 #3
Frank,

Thanks a lot I never saw that one.

:-)

Cor

"Frank" <fr***@frank.com>
..
Cor, I think you are mistaken. A dataview has a find method, it works on
the
sorted column(s).
Frank

"Cor Ligthert" <no************@planet.nl> wrote in message
news:uN*************@TK2MSFTNGP11.phx.gbl...
S. Hoa,

I think that the most easiest way is to get your row is to create another
(extra) dataview.

A dataview is just a filter on your table.

There is no dataview find, because that belongs to the datarowcollection.

Use on that other dataview the rowfilter what is very easy to use.

Possible
is as well the datatable.select. Beneath in another message I have send

the
links of explanations for all those to somebody else.

http://groups.google.com/groups?selm...tngp13.phx.gbl

I hope this helps?

Cor

"HS1" <so*@slingshot.co.nz>
>
> To present (and manipulate) data in a table, I use an DataGrid and a
> DataSet
> "ds"
>
> DataGrid1.DataSource = ds
>
> However, to search a record in this DataGrid, I have to use DataView "dv" >
> DataGrid1.DataSource = dv
> int = dv.Find (.......)
>
> Can I use only one of them for both searching and manipulating data for a > table
>
> Thank you very much
> Best regards
> S.Hoa
>
>



Nov 21 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: CharitiesOnline | last post by:
Hello, I have set this script up to add paging to a search results page. Which on the first page works fine. I calculates how many pages there should be depending on the number of results returned...
2
by: TH | last post by:
I am (still :) working on a recipe database. Now I am trying to figure out how to set it up for an ingredient search. What I want it to be able to do is to search by one ingredient, sometimes by...
3
by: AW | last post by:
Hi all, I have a form (named Offices) with a subform (named Occupants) that connect with the Master/Child Field "office number". I have a combo box that allows a user to pull up a particular...
8
by: Steph | last post by:
Hi. I'm very new to MS Access and have been presented with an Access database of contacts by my employer. I am trying to redesign the main form of the database so that a button entitled...
4
by: RoadRunner | last post by:
Hi, I have a question. I am asked to produce a global search of a given corporate name, in more that one database. Each database has different table names and different field names in the tables....
3
by: vonclausowitz | last post by:
Hi All, I was thinking of creating a table in my database to index all words in the database. That way I can quickly search for one or more words and the index table will return the words and...
1
by: Eric | last post by:
Hi: I have two files. I search pattern ":" from emails text file and save email contents into a database. Another search pattern " field is blank. Please try again.", vbExclamation + vbOKOnly...
3
by: bluez | last post by:
I want to design a webpage where user can search the data from the database and list out the related records. Each of the record got a delete button which allow user to delete the record. ...
9
by: hrreece | last post by:
I have an Access 2002 database that has a form that can be used to review individual records. At the bottom of the form are buttons that are linked to functions that allow the user to "Find a record...
13
by: jfarthing | last post by:
Hi everyone! I am using the script below to search a db. If the is more than one match in the db, all goes well. But if there is only one match in the db, nothing gets displayed. Any...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.