SELECT 
	f.fin_id AS `id`, 
	f.fin_text AS `What`, 
	concat('$', f.fin_amt) AS `Amount`, 
	DATE_FORMAT(f.fin_occur, '%m/%d/%Y') AS `Date`,
	f.fin_added,
	SUM(f2.fin_amt) as `Balance`
FROM finances f,
finances f2
WHERE f.fin_domain = 'CC'
	AND DATE_FORMAT(f.fin_occur, '%Y') = '2007'
	AND DATE_FORMAT(f.fin_occur, '%m') = '10'
	AND f2.fin_domain = 'CC'
	AND f2.fin_occur <= f.fin_occur
GROUP BY f.fin_id
ORDER BY f.fin_occur, f.fin_added

	AND (    f2.fin_occur < f.fin_occur
	      OR (     f2.fin_occur = f.fin_occur
	           AND f2.fin_added <= f.fin_added ) )

    public class Transaction
    {
        public Transaction(int id, string what, double amount, DateTime transactionDate, DateTime addedDate)
        {
            _id = id;
            _what = what;
            _amount = amount;
            _transactionDate = transactionDate;
            _addedDate = addedDate;
        }

        private int _id;
        private string _what;
        private double _amount;
        private DateTime _transactionDate;
        private DateTime _addedDate;

                public int Id
        {
            get { return _id; }
            set { _id = value; }
        }
        public string What
        {
            get { return _what; }
            set { _what = value; }
        }
        public double Amount
        {
            get { return _amount; }
            set { _amount = value; }
        }
        public DateTime TransactionDate
        {
            get { return _transactionDate; }
            set { _transactionDate = value; }
        }
        public DateTime AddedDate
        {
            get { return _addedDate; }
            set { _addedDate = value; }
        }
    }

    public class RunningTransaction
    {
        public RunningTransaction(Transaction transaction, double runningTotal)
        {
            _transaction = transaction;
            _runningTotal = runningTotal;
        }

        private Transaction _transaction;
        private double _runningTotal;
        
        public int Id
        {
            get { return _transaction.Id; }
            set { _transaction.Id = value; }
        }
        public string What
        {
            get { return _transaction.What; }
            set { _transaction.What = value; }
        }
        public double Amount
        {
            get { return _transaction.Amount; }
            set { _transaction.Amount = value; }
        }
        public DateTime TransactionDate
        {
            get { return _transaction.TransactionDate; }
            set { _transaction.TransactionDate = value; }
        }
        public DateTime AddedDate
        {
            get { return _transaction.AddedDate; }
            set { _transaction.AddedDate = value; }
        }
        public double RunningTotal
        {
            get { return _runningTotal; }
            set { _runningTotal = value; }
        }
    }

    public class DataAccess
    {
        // This is the results of your MySQL query:
        private IEnumerable<Transaction> GetTransactions()
        {
            yield return new Transaction(21, "Home Depot (Coffee Table)", 20.29, new DateTime(2007, 10, 3), new DateTime(2007, 10, 7, 19, 17, 15));
            yield return new Transaction(23, "Best Buy (Mario Party + Wiimote)", 96.75, new DateTime(2007, 10, 3), new DateTime(2007, 10, 7, 19, 17, 45));
            yield return new Transaction(22, "Price Chopper", 6.63, new DateTime(2007, 10, 4), new DateTime(2007, 10, 7, 19, 17, 31));
            yield return new Transaction(27, "Connections (Ice Cream Sandwiches)", 3.29, new DateTime(2007, 10, 5), new DateTime(2007, 10, 7, 19, 19, 54));
        }
        // This is the result of another query to calculate the starting balance of the above query
        private double GetStartingValue()
        {
            return 264.17;
        }
    }

        // This is what you provide to your datagridview control
        public IEnumerable<RunningTransaction> GetTransactionsWithRunningTotal()
        {
            double runningTotal = GetStartingValue();
            foreach (Transaction t in GetTransactions())
            {
                runningTotal += t.Amount;
                yield return new RunningTransaction(t, runningTotal);
            }
        }

Imports DataAccess.DataAccess
Imports DataAccess.RunningTransaction

    Public Sub New()

        ' This call is required by the Windows Form Designer.
        InitializeComponent()

        ' Add any initialization after the InitializeComponent() call.
        Dim da As DataAccess.DataAccess = New DataAccess.DataAccess()
        DataGridView1.DataSource = BindingSource1
        BindingSource1.DataSource = da.GetTransactionsWithRunningTotal()

    End Sub

SET @total - 0;
SELECT 
	fin_id AS `id`, 
	fin_text AS `What`, 
	concat('$', fin_amt) AS `Amount`, 
	DATE_FORMAT(fin_occur, '%m/%d/%Y') AS `Date`,
	fin_added,
	@total := @total + fin_amt AS `Balance`
FROM finances
WHERE fin_domain = 'CC'
	AND DATE_FORMAT(fin_occur, '%Y') = '2007'
	AND DATE_FORMAT(fin_occur, '%m') = '10'
GROUP BY fin_id
ORDER BY fin_occur, fin_added;

SET @total - 0;
SELECT 
	fin_id AS `id`, 
	fin_text AS `What`, 
	concat('$', fin_amt) AS `Amount`, 
	DATE_FORMAT(fin_occur, '%m/%d/%Y') AS `Date`,
	DATE_FORMAT(fin_added, '%m/%d/%Y') AS `Added`,
	concat('$', @total := @total + fin_amt) AS `Balance`
FROM finances
WHERE fin_domain = 'CC'
	AND DATE_FORMAT(fin_occur, '%Y') = '2007'
	AND DATE_FORMAT(fin_occur, '%m') = '10'
GROUP BY fin_id
ORDER BY fin_occur, fin_added;