datagrid and radio button

[smithbr]

hello all,
Does anyone know how to make it so that a column that is calculated will base its calculation on which of two radio buttons is checked. IF yes is check I want the calculation to take the discount off the total, if no is checked I do not wan tit to take the discount off the total. Also, If I do this i am assumming I will need to have some event behind the buttons themselves in case the user changes after the datagrid has been filled...here the code that I tried...does anyone know what I should do?

OleDbDataAdapter1.SelectCommand.Parameters(0).Value = txtinvnum.Text
OleDbDataAdapter1.Fill(DsInvoice1)
Try
DsInvoice1.Tables(0).Columns.Remove("Total&quot
Catch
End Try

DsInvoice1.Tables(0).Columns.Add("Total&quot
Dim dr As DataRow

If rdoyes.Checked Then
For Each dr In DsInvoice1.Tables(0).Rows
dr.Item("Total&quot = ((dr.Item("QuantityShipped&quot * dr.Item("LastUnitPrice&quot) * (1 - dr.Item("DiscountP&quot))
Next
grdComm.DataSource = Nothing
grdComm.DataSource = DsInvoice1
ElseIf rdono.Checked Then
For Each dr In DsInvoice1.Tables(0).Rows
dr.Item("Total&quot = dr.Item("Total&quot = dr.Item("QuantityShipped&quot * dr.Item("LastUnitPrice&quot

Next
grdComm.DataSource = Nothing
grdComm.DataSource = DsInvoice1
End If