Member Avatar for paulablanca

Hello! Can someone help me? I need to get the product of the 2 columns in the same row but my problem is the values of my datagridview come from database and the number for rows is not fixed. Thank you very much and God Bless. :)

  • 2 Contributors
  • 2 Replies
  • 76 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by paulablanca
Member Avatar for Saranya Asokan

Hi ....
try this code.........


For i = 0 To TempDataset.Tables(0).Rows.Count - 1
Dim Productvalue As Double = 0
Productvalue = Val(TempDataset.Tables(0).Rows(i)("BillAmount").ToString) * Val(TempDataset.Tables(0).Rows(i)("BillAmount").ToString)
PatientDataGridView.Rows.Add(TempDataset.Tables(0).Rows(i)("PatientID").ToString, TempDataset.Tables(0).Rows(i)("PatientName").ToString, _
TempDataset.Tables(0).Rows(i)("BillAmount").ToString, TempDataset.Tables(0).Rows(i)("Commission").ToString, Productvalue)


Next

Member Avatar for paulablanca

May I ask, "BillAmount" is for what? Thanks and God Bless. :)

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.