private void RefreshCounts()
{
foreach (var row in itemsDataGridView.Rows.Cast<DataGridViewRow>().Where(col => col.Cells[1].Value != null)) {
var countsTableAdapter = new InventoryDataSetTableAdapters.CountsTableAdapter();
var dataAdd = Total(countsTableAdapter.GetData().Where(rowCount => rowCount.SKU == (string)row.Cells[1].Value && rowCount.Add));
var dataRemove = Total(countsTableAdapter.GetData().Where(rowCount => rowCount.SKU == (string)row.Cells[1].Value && !rowCount.Add));
row.Cells[6].Value = dataAdd - dataRemove;
}
}
