I have been trying to set up a database in VB 2010.
I have a table Called: Sales, which contains following columns,
Price, Quantity, Tax and Amount.
What I wish to do is, Multiply, Price, Quantity and Tax data to Amount Column instantly as the above fields are entered.
I have created a database using MSSql.
When I try adding a query to the default TableAdapter, it gives something called as Schema error.
So, I added a new Adapter and a query,
SELECT PRICE, TAX, Quantity, PRICE*TAX*Quantity AS Amount FROM sales
It got executed correctly, but I am unable to get it working with the table.
What should i do?