A voir également:
- Insérer des données modifiées sur datagridview dans BD sqlserver
- Fuite données maif - Guide
- Insérer vidéo dans powerpoint - Guide
- Insérer signature word - Guide
- Insérer liste déroulante excel - Guide
- Insérer sommaire word - Guide
1 réponse
voici le traitement que je fais
Private Sub DataGridView1_CellValueChanged(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView1.CellValueChanged
If sql.connect = True Then
Dim i As New Integer
While (i < DataGridView1.RowCount)
sql.exereq("update avance set montant='" & DataGridView1.Rows(i).Cells(3).Value & "' where IdFuncionario='" & DataGridView1.Rows(i).Cells(0).Value & "'")
i += 1
End While
End If
End Sub
Private Sub DataGridView1_CellValueChanged(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView1.CellValueChanged
If sql.connect = True Then
Dim i As New Integer
While (i < DataGridView1.RowCount)
sql.exereq("update avance set montant='" & DataGridView1.Rows(i).Cells(3).Value & "' where IdFuncionario='" & DataGridView1.Rows(i).Cells(0).Value & "'")
i += 1
End While
End If
End Sub