Hello
To present (and manipulate) data in a table, I use an DataGrid and a DataSet
"ds"
DataGrid1.DataS ource = ds
However, to search a record in this DataGrid, I have to use DataView "dv"
DataGrid1.DataS ource = 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
3  1245 
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 datarowcollecti on.
Use on that other dataview the rowfilter what is very easy to use. Possible
is as well the datatable.selec t. 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.DataS ource = ds
However, to search a record in this DataGrid, I have to use DataView "dv"
DataGrid1.DataS ource = 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
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******** *****@TK2MSFTNG P11.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 datarowcollecti on.
Use on that other dataview the rowfilter what is very easy to use.
Possible is as well the datatable.selec t. 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.DataS ource = ds
However, to search a record in this DataGrid, I have to use DataView
"dv"
DataGrid1.DataS ource = 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
Frank,
Thanks a lot I never saw that one.
:-)
Cor
"Frank" <fr***@frank.co m>
.. 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******** *****@TK2MSFTNG P11.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 datarowcollecti on.
Use on that other dataview the rowfilter what is very easy to use.
Possible is as well the datatable.selec t. 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.DataS ource = ds
>
> However, to search a record in this DataGrid, I have to use DataView "dv" >
> DataGrid1.DataS ource = 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
>
>
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
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 from my search and how many
records I have set it to display per page. All great so far, HOWEVER.....
When you click the next link to see the...
|
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 two, and sometimes by three.
There won't always be a second and third ingredient to search on. It will
depend on how the user wants to search.
...
|
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 office and see the listing of its occupants,
no problem.
Next, I tried to create a combo box that would allow users to search for a
particular...
|
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 'search' may be clicked on by the user and the user can then
search all records by postcode. I want to do this to prevent duplicate
data entry.
|
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. Does
anyone know if this can be done? Thanks
| | |
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 records I need.
For example the iTable would look like this:
|
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
Me.txtEmail.SetFocus
Exit Sub
End If
Me.txtStatusBar.Value = "Parsing..."
strEmail = Me.txtEmail.Value
|
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.
Filename : search_student.php
<?php
include("../user_access/user_access_control.php");
include("../Database/database.php");
$searchStudentControl =...
|
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 using search criteria", "Delete the current record" and so on. After a user has used the search criteria to find a specific record, I would like to...
|
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 suggestions will be greatly appreciated.
Jim
#! /usr/bin/perl -w
use strict;
|
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |
