Hello. I have a database with a table containing multiple prices for a single product and there are multiple products in the table.
I need to get a specific price depending and the amount of product. If a customer has 100lbs he gets 3.50 a product if he has more he gets 3.45...
i need it to read a txtbox for the amount Then get the right price from the database. But i have no clue how to do it. Im not sure if it must be done from the Sql statement or in the .vb file.
dkba27
Member
17 Points
18 Posts
Getting Data Depending On Control
Feb 10, 2012 06:37 PM|LINK
Hello. I have a database with a table containing multiple prices for a single product and there are multiple products in the table.
I need to get a specific price depending and the amount of product. If a customer has 100lbs he gets 3.50 a product if he has more he gets 3.45...
i need it to read a txtbox for the amount Then get the right price from the database. But i have no clue how to do it. Im not sure if it must be done from the Sql statement or in the .vb file.
Database sql textbox