ms access Matrix / Array database for vb.bet

Question

1.00/5 (1 vote)

See more:

, +

Hi I have a problem how to set the data base
I am using Ms access VB.net Strongly typed Data base
now i have 500 products
each product got 2 criteria for price W and H
so i used to have like a matrix on excel with 500 tables

ex

first table (Product A)
column 100 150 200 300
row 50 60 70
and the cell intersection is the price

second table (Product B)
column 135 145 205 310
row 54 62 75
and the cell intersection is the price

now to make an access database to be used in Visual studio VB.NET
what i need to do at the end is when i choose A 100 50 I get the price
do i have to make 500 tables!!! or is there an easier faster way
(Update "Their is no formula or pattern for any number :S")

can i make a 3D array in each access cell, then when i call that cell i have to give 2 parameters and it gives me the 3rd one ,so i call A, 100, 50 and it gives the price!?

Thanks

Posted 16-Jun-14 15:43pm

Member 10862570

Updated 16-Jun-14 16:45pm

v5

Add a Solution

Comments

Peter Leow 16-Jun-14 22:19pm

How was the price for each product derived? Any formula?

Member 10862570 16-Jun-14 22:30pm

Thanks
No, No formula

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)

Raghubir_Sarkar · Accepted Answer · 2014-06-16T19:34:00

Solution 1

Make table like this -

ID - Product - W_Price - H_Price
1 - A - 100 - 50
2 - A - 150 - 60
3 - B - 135 - 54
4 - B - 145 - 62

By this way you can save your 500 products into 1 table also you can get any value using combination of columns in your select query.

Posted 16-Jun-14 19:34pm

Raghubir_Sarkar

Comments

Member 10862570 17-Jun-14 2:39am

It's a good solution thank you, but I didnt want to do it that way cause i will have like 1000000 rows :D

Raghubir_Sarkar 17-Jun-14 2:48am

Ya in access it is slow to get a single value from huge amount of rows but for SQL its a good solution. If in your project products are grouped into 2 or 3 group then you can create separate table for groups and implement this solution but making so many tables for each type of product will also slow the execution and it doesn't make any seance.