How to use a datatabe to search db

Question

1.00/5 (1 vote)

See more:

Hi All

I’m very new to vb.net programming and all of what I have learnt has been self taught.

I’m having difficulty with an aspect of what I would like my application to do and if this is possible.

I require the application to be able to search a database base on a unique code for each product, but be able to type this code into a table like display and once entered a search will happen and fill the rest of the table with the contents from a database that mach the product ID. The user will then be able to enter more products and once finished save the table into an Access db.
The product information is in DBF database.

Thank you for your help and time

Danny

Posted 18-Jul-11 10:38am

DAN9878

Updated 19-Jul-11 10:57am

v2

Add a Solution

Comments

Joan M 19-Jul-11 17:04pm

which database are you using? and more important... what do you need? what have you tried and where are you stuck?

DAN9878 19-Jul-11 17:12pm

Hi thanks for your reply

This application is going to be used as a stock counting app, where the user will add products to a data grid using the product codes and the rest of the product information will inserted into the data grid based on the code.

The products are in a .dbf table, I am able to connect to the database and display the data in the data grid, but I’m showing all products.

Danny

Ps the connection I’m using is OLE DB Visual FoxPro

Joan M 20-Jul-11 2:02am

And which is your query to the database?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

thatraja · Answer 1 · 2011-07-18T16:16:00

Solution 1

You didn't mention the database

vb.net search database[^]

Posted 18-Jul-11 16:16pm

thatraja

Comments

Espen Harlinn 19-Jul-11 16:52pm

That's a few options, my 5