search method

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.... :wave:

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

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?

No datagrid involved. Just a straight SQL SELECT statement

Code:

---

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.

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

What do you mean by searchstring?

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.... :D