Imports System.Data.OleDb Public Class Form1 Dim Cnx As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\TESTIMG.mdb;Persist Security Info=False") Dim Dst As New DataSet Dim Com As New OleDbCommand("Select * from Clients", Cnx) Dim Da As New OleDbDataAdapter(Com) Dim ComB As New OleDbCommandBuilder(Da) Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load 'chargement des données Da.Fill(Dst, "Clients") 'Databinding de la datagridview1 et le dataset DataGridView1.DataSource = Dst DataGridView1.DataMember = "Clients" End Sub Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim rst As Integer 'Mise a jour de la table Clients rst = Da.Update(Dst, "Clients") If rst <> 0 Then MsgBox("Mise a jour effectué de " & rst & " ligne(s)") End If End Sub End Class
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question