hello!
i'm new to vb.net and have very little knowledge of it especially when it comes to databases so i'm not really sure i can give a sample code right now. maybe if it's vb6 then that might be different but i'm supposed to use this :D
maybe screenshots on what i'm doing would work for now.
right now i'm working on a coffee shop inventory system but my concern for now is this...
here's my problem
i need help on how to update records on an existing access database using vb.net with just a textbox and a command button and how a specific record of a field can show up in a label or a textbox
i connected vb.net to my access database by just clicking on "add new data source">>"new connection">>"microsoft access database file" and just continue..tested connection and done.
as you can see in the screenshot of my form, by default the left side textboxes are disabled but they're enabled if the user checks the checkboxes and disabled again if unchecked.
assuming that the textbox is already enabled and i want to enter a value in the Brewed Coffee area of the form...for example 5. when i click on my Submit button the value of that particular record in the database will be updated, so in my table the value of the quantity field in Brewed Coffee will be 5.
another thing is that how can i see a particular value on a label or textbox from my database like on the Prices area. in my database if a product's price is 80 then it should show a 80 in the label. the values of the prices from the screesnshot of the form are not the ones on the database xD i just typed them in...
just guide me to the right path po!
thanks!!
helpful hints, tips, and suggestions will be greatly appreciated
i'll try to add more info if needed
- Add new comment
- 35 views