| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 139578 | 2015-05-26 03:24:00 | VB.Net MS Access help | Mike (15) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 1401360 | 2015-05-26 03:24:00 | Hoping someone here can help (or point me at useful documentation/webpage that could be useful) Writing a small app in VB.Net (just for fun, at home...) and trying to pull values from an Access Database (either .accdb or .mdb) however I can't figure out how to get my app to talk to the database. Tried a few examples from the web but they all throw errors. Can someone point me in the right direction for how to connect to and query an Access DB from a VB.Net form? I have two input fields, and I would like to query the db based on the values in those two fields, to return a third value. I don't need to return more than one value, and I don't need to write anything. There are 57 rows and 7 columns. First value I want to query is from the first column, second value determines which of the remaining 6 columns to select from (in the form of selection from 1-6), so using the table below, if someone input 20000 in the first textbox and 4 in the second textbox it would return a value of 103. Amount V1 V2 V3 V4 V5 V6 10000 10 20 30 40 50 60 20000 100 101 102 103 104 105 30000 110 115 120 125 130 135 40000 200 400 600 800 1000 1200 My problem seems to be that I can't get my app to connect to my DB, but I'm not entirely sure. Didn't think it'd be that difficult to find help on the web for something like this :) Cheers, Mike. |
Mike (15) | ||
| 1401361 | 2015-05-26 03:35:00 | Or would it be better to store my table in a different format? Different kind of DB file perhaps, or XML or Excel or something else? Cheers, Mike. |
Mike (15) | ||
| 1401362 | 2015-05-26 05:58:00 | CSV is probably your best bet. | Alex B (15479) | ||
| 1 | |||||