medicenpringles
Programmer
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
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