How to auto calculate two rows into third one in datagridview table who uses access database

Question

I insert Access database into Visual Studio Basic. I have put datagridview on the form who uses same database. What i am ask is: How to auto calculate one of the row cell as product of another two, within same datagridview, same database. When you enter value in the rows to auto calculate value without using another button or extra code?

Answer 1

Hello @DRGAGI

In the .xsd file, select the table, add a new column

Now setup the Expression for the column just added. In the following UnitPrice column exist in the database table as a decimal, the new column has been setup as a decimal and an Expression as shown. This works when saving as the column is ignored by the database classes.

Does this make sense?

Answer 2

Hi @DRGAGI ,
As LesHay suggested, you need to add following code in your 'Form.Load' event.

yourDataSet.Tables("yourTable").Columns("TotalColumnName").Expression = "yourColumnName1 * yourColumnName2"  

Result of my test.

Best Regards,
Xingyu Zhao
*
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

Hi
You could use Expressions to do this. See HERE for details.

Answer 4

Thank you for your support guys. Code works fine, but when i want to save database i get this error

Answer 5

Public Class Form1
    Private Sub Table1BindingNavigatorSaveItem_Click(sender As Object, e As EventArgs) Handles Table1BindingNavigatorSaveItem.Click
        Me.Validate()
        Me.Table1BindingSource.EndEdit()
        Me.TableAdapterManager.UpdateAll(Me.DatabaseTestDataSet)

    End Sub

    Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
        'TODO: This line of code loads data into the 'DatabaseTestDataSet.Table1' table. You can move, or remove it, as needed.
        Me.Table1TableAdapter.Fill(Me.DatabaseTestDataSet.Table1)

        DatabaseTestDataSet.Tables("Table1").Columns("sum").Expression = "a1 * a2"


    End Sub
End Class