its a very deficult situation for me, bcoz i am not expert thats way taking help from u all.
i m creating a project for commission calculation type
in the form i have one combobox which is filled by ms access database containing parent ID.
these parent ID have there Agent under them and the amount deposited by this parent should be distributed to all the agent also.
if the parent deposite 100 rs then the total amount should be distributed to 2 agent under their parent as per the %ntg.
i am also filling datagridview like this:
Public Sub Fillteam() DataAdapter1 = New OleDbDataAdapter("Select * From agency_reg WHERE" _ & "[parentID] = '" & agid.Text & "' ORDER BY agency_ID", Conn) Dim ds As New DataSet ds.Clear() DataAdapter1.Fill(ds, "agency_reg") DGVteam.DataSource = ds.Tables(0) DGVteam.Refresh() End Sub
the column in datagridview are:
1. agent ID
2. agent name
so as per the rank and percentage the amount in the textbox must be calculate.
and is it also possible to save this all calculation to database.
sorry i am very new in programming.if want more information then please tell.
kindly help me fort this.
thanks in advance....("_")