Hello guys,
I'm working on a VB.Net Project. I'm using MS SQL Server as my backend.
I can create Purchase/Sales Voucher forms and many more through the VB.Net Database EXpress.
Say for example I have created a Purchase Voucher form where the user can enter the vendor info (in TextBox view) as well as the the Product, Quantity, Rate , Totals (in Datagridview). thus the user can save the purchase voucher to the database as for record.
BUT THE PROBLEM IS THAT I also want that when the user enters the Product, Quantity, Rate, etc. the stock also get increased (updated) automatically.
IN THIS CASE I NEED YOUR 'VALUABLE SOLUTION'
Thanks!!
arsharma159
0
Newbie Poster
Recommended Answers
Jump to PostYou'll probably not want to increase the "stock on hand" until you take delivery. What I recommend is to track that amount in a separate column, "On Order" . If you have MSAccess, there's a pretty good inventory layout in the Northwind sample …
Jump to PostYou want an update query.
Assuming you have a TableAdapter (visible in the "tray" in Form Designer View), AND the table you want to update is already in your dataset:
- Right click that TableAdapter and select "Edit Queries in DataSet Designer"
- In DataSet Designer right-click the main table to be …
Jump to PostClean your project from the Build menu, zip it up into a compressed folder, and attach it to a post.
We need to see what you have for code, if you've done everything in the designer so far, you won't see anything in your main form's code behind file - …
Jump to PostYou really should've used the Northwind example and modded it to suit your needs...
Some quick notes:
1. Database design is "off" - Customer table and Vendor table have no relation to any other tables
2. Add POrder.POID as a foreign key to vendor table, add SOrder.SOID as foreign key …
All 16 Replies
john.knapp
25
Posting Whiz in Training
arsharma159
0
Newbie Poster
john.knapp
25
Posting Whiz in Training
arsharma159
0
Newbie Poster
arsharma159
0
Newbie Poster
john.knapp
25
Posting Whiz in Training
arsharma159
0
Newbie Poster
arsharma159
0
Newbie Poster
john.knapp
25
Posting Whiz in Training
john.knapp
25
Posting Whiz in Training
ranvijay005
0
Newbie Poster
arsharma159
0
Newbie Poster
arsharma159
0
Newbie Poster
john.knapp
25
Posting Whiz in Training
arsharma159
0
Newbie Poster
Jhenzkieskipper
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.