I have a datagrid in vb6. It is accessing an SQL Express 2005 database. In the database I have a column that totals some of the other columns.
When I pull up that table in the datagrid, I normally enter numerical values in the columns. The problem is that when I enter it and then move to the next row, the Total column does not automatically update. However, if I look at the DB at the same time, I can see it is certainly adding. The problem is that it is clearly not updating to the datagrid.
If I retrieve the values from the whole grid then it updates the Total column, but I would rather like to see it update without having to do that. Any suggestions?