suma % en un GRID

[guillebomtrasmiti]

asi me funciona pero me cambia toda la tabla y yo solo quiero lo que está filtrado en el datagrid...alguien me ayuda=?

Dim col As DataGridViewColumn = Nothing
Dim i As Integer = 0

Do While (i < DgTotales.Columns.Count)
If i = 0 Then
col = DgTotales.Columns.GetFirstColumn(DataGridViewEleme ntStates.Visible)
Else
col = DgTotales.Columns.GetNextColumn(col, DataGridViewElementStates.Visible, DataGridViewElementStates.None)
End If

MsgBox(col.Name.ToString)
i = i + 1
Loop
Dim resta As New Integer
Dim resultado As New Integer

Dim com = conexion.CreateCommand

Dim adapt As New OleDbDataAdapter
Dim setda As New DataSet

adapt.SelectCommand = com
For Each row As DataGridViewRow In DgTotales.Rows
com.CommandType = CommandType.Text
com.CommandText = "UPDATE IntroduccionDeVentasAhora SET Pts =ROUND (Pts /" & TxtPorcentaje.Text & " *100,2) Where NombreFormaPago <> ('TARJETA CREDITO') and " & DgTotales.Columns.Item("Pts").Index.ToString & ""
adapt.Fill(setda, "IntroduccionDeVentasAhora")

Next