search method

[ungas023]

hello,
i am making a project using search method, i am using a textbox for inputing the codenumber and 2 lblboxes for showing me the product name and the product price, how can i array this and what method should i use? i am using a DB in access2000 and how can i access the fields that being set? tnx....

[dee-u]

Do you already know how to access a database? You could execute an sql against the database if that is what you want.

[ungas023]

nope, can you tell me what sql statement should i use, and i know how to access a DB, it is on the properties of the data grid? right?

[Hack]

No datagrid involved. Just a straight SQL SELECT statement

SELECT product_name, product_price FROM yourtable
WHERE product_code = '" & txtproductcode.text & "' "

Naturally you have to change the field names and textbox name to reflect what you are actually using. Also, if the product code is stored as a numeric you do not need the single quotes.

[ungas023]

tnx for your reply guys, it did work... one more question, how do you use a searchstring? i am totally confused on this feature...

[dee-u]

What do you mean by searchstring?

[ungas023]

for example i want to search a DB for a certain string, i guess it goes like this search$ from this column from cell1 to cell10, how do i express it in code?, tnx....