Member Avatar for Priya_14 
I have database table created in sql server visual studio.I have one dashboard kind ,so whenever i want to change the value  automatically balance amount should caluclate and display the changed value.

Su Si Sa Sd Balance
10 12 13 14 ( Balance=Su+Si+Sa+Sd)
14 15 13 17 ( Balance=Su+Si+Sa+Sd)
17 18 19 15 ( Balance=Su+Si+Sa+Sd)
I want result like this.Please help me as soon.I am using VB for this project.

Edited by Priya_14
  • 1 Contributor
  • 1 Reply
  • 479 Views
  • 23 Hours Discussion Span
  • Latest Post Latest Post by Priya_14
Member Avatar for Priya_14 
 Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
    'TODO: This line of code loads data into the 'Database3DataSet.Tools' table. You can move, or remove it, as needed.

    Me.ToolsTableAdapter.Fill(Me.Database3DataSet.Tools)

End Sub

Private Sub ToolsBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ToolsBindingNavigatorSaveItem.Click
    Me.Validate()
    Me.ToolsBindingSource.EndEdit()
    Me.TableAdapterManager.UpdateAll(Me.Database3DataSet)

End Sub

This is my code,i dont know from binding navigator how to do the sum of multiple  cells in a row.Please help me
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.