I'm Developing A very Basi App For Generating Bill On A retail shop I'm Using Access(mdb) As Data Base The Table with Name "Invoice"(Holds grand Total And Deposited Against That Invoice) On which I wants to perform task has fields As Follow:
InvoiceId , CustomerId , CustomerName , InvoiceTotal , InvoiceDeposited, InvoiceDate
Now ON my C# Form There Are A text Box for entering CustomerId On text Change Event I wants To Get The Due Amount Till Now And I wants TO Bound That Value to A Lable
Lable.text=( (Sum Of All InvoiceTotal Entries For that CustomerID) - (Sum Of All InvoiceDeposited Entries For that CustomerID) )
How to reach the Desired Result ...??. Please Help ..!!