datagrid calculation

S

Smithbr

Member
Joined
Jun 3, 2003
Messages
15
Hello all,
I just finished this VB.net program I was working on and started testing it when I noticed a huge hole in it that some how I missed from the beginning.

I have a datagrid that is filled based on a access DB. The columns that are in the datagrid include: lineseqno, itemnumber, quantity, unit price, and discount %. I also have a column that is created at run time called Total that is quantity * unit price.

Now to my question: How can I either get the total column to update to the database even though it is not part of the data adapter. (I created the DA and DS at design time) If that will not work, how can I get the unit price to change based on if a radio box is selected (if a discount was taken, make unit price = unit price*(1-Discount%) ). I am not sure how to do this either way..and both I think will fit my purpose. Any suggestions?
Thanks.
 
I donot whether this would help or not.
Iam not sure what you want, this what I understood from your question.

This will get the discount value.
dim price_chng as Int16 = radiobutton1.selectedItem.value

As you have the datatable and it has the unitprice, uisng the rows and columns in the datatable get the respective unitprice value and store in a variable and apply the didcount one.


dim pirce_dis as int16
price_dis= price_chng * unitprice

the unitprice is the one which is selected based on the item, if your program is that or get the unitprice of the item which you want to apply the discount,, by using the datatable of the dataset


dim oledb_comm as new OleDb.OleDbCommand
oledb_comm.commandtext="Insert into table (unitprice) values("&price_dis&")

By this you can change the unitprice of the selected discount.
 
Back
Top