access connections through code

[medicenpringles]

ok, this is going to sound a bit odd because i've never done this before, but here goes:

i have a cash register application that involves several classes and several forms. i have a Globals module that holds all my constants and such, and i have a class named "Prices" that holds all the prices of my products. that class has properties for the name and size of a product, and a big long complicated set of "Select Case" statements for the prices.

what i would like to do is have a database (which is already made) that i connect to through the Prices or Globals that stores all my prices. i want my Prices class to dynamically look up prize by name and size according to what controls the user inteacts with.

basically, i'm looking for the vb.net equivelent to the VLOOKUP funtion in excel, but for Access databases.

sry if that was confusing.

thanks
stephen

ps - i know this is probably all explained in the ADO.NET core reference, but i'm on a low budget right now.

Main Language: Visual Basic .NET
Development Environment: Visual Studio .NET 2003

 

[medicenpringles]

summarization of above:
1) how do i connect to a access database programmatically?
2) how do i look up specific values in that database?

Main Language: Visual Basic .NET
Development Environment: Visual Studio .NET 2003

 

[medicenpringles]

does no one know what i'm talking about? it doesn't seem that hard.

Main Language: Visual Basic .NET
Development Environment: Visual Studio .NET 2003

 

[chrissie1]

I think everybody thinks that you could easily look this up but me shall give it a try.

tip 1:

http://www.connectionstrings.com

tip 2:

dim contemp as new oledbconnection
dim comtemp as new oledbcommand
dim adptemp as new oledbdataadapter
dim dttemp as new datatable

contemp.connectionstring = 'see tip1
comtemp.commandtext = "select * from sometable"
comtemp.connection = contemp
adptemp.selectcommand = comtemp
adptemp.fill(dstemp)

tip 3: "select * from sometable WHERE field = value"

tip 4: I'm in good mood.


Christiaan Baes
Belgium

I just like this --> [Wiggle] [Wiggle]

 

[BobRodes]

Tip 5:

http://www.google.com.

Try entering "vb.net database connection".

Tip 6: Be nice. People who help you are doing you a favor.

Bob