Calculated field in datagridview
Posted on 2007-09-28
Below is part of a posting to the MS SQL Server site. I know that most of you on this site use SQL Server for database connectivity.
"For those of you who may be familiar with the look of Quickbooks' check register where a check transaction has two lines associated with it and the grid has a running account of a balance field out beside each combined transaction, I am looking at designing a sql statement that gives me that capability."
In the event I am able to create a dataview with the rows I specify above, I want to incorporate into a datagridview that contains several editable fields....one of which is the check_amount where I can refresh the SQL statement above and recalculate the balance field.
Should I be able to do this with the default datagridview in VB 2005 or do I need to look for a 3rd party grid to make my life easier with this function. Depending on this, I can incorporate this grid in about 7-8 other accounting forms/datagridviews for more flexibility and/or ease of use/design.