How should I implement this scenario?

  • Thread starter Thread starter Slonocode
  • Start date Start date
S

Slonocode

On one form I used the designer to to create connection, data adapter, and
dataset objects(OLEDB) for an Access database. The form has many textbox
fields which are databound to the dataset. The data adapter returns a
subset of the information in the .mdb file.

I would like the user to be able to open another form from which they could
perform searches on the same .mdb file. Something like a textbox to enter
search criteria and a button to initiate search. This would only need to be
read only as I wouldn't want them editing the data from this form. The form
would just have a datagrid with a tablestyle applied for viewing the
results. Which objects should I use so that I can have a dynamic Select
statement depending on the info in the text box?


Should I just use brand new objects for this second form or should I be
trying to reuse previous objects for the database? Should perhaps create a
component that to access the database?

Also When I use the server explorer to create these objects the connection
string uses the absolute path to the .mdb file. Which is fine while I'm on
my machine but what about when I want to run the app on a different machine?


Thanks for any help
Slonocode
 
Hi,

You'll will want to use a newly created object - probably a dataview -
because the 'base' form has access to the data and can change it at any
time. Shouldn't be difficult to pass the textbox.text into a .find method
of a dataview or even to do a more direct seek of the full table itself.

HTH,
Bernie Yaeger
 
Back
Top