sSQL = "SELECT * FROM Tireurs T, Societe S WHERE T.T_IdSociete = S.S_IdSociete ORDER BY T_Nom, T_Prenom;"
Cl25m_Connection = New OleDbConnection
Cl25m_Connection''Ouvrir la connection
Cl25m_Connection.Open()
Cl25m_Command = New OleDbCommand(sSQL)
Cl25m_DataAdapter = New OleDbDataAdapter(Cl25m_Command)
Cl25m_Command.Connection = Cl25m_Connection
Cl25m_DataAdapter.Fill(Cl25m_DataSet, "Tireurs")
Cl25m_DataTable = Cl25m_DataSet.Tables("Tireurs")
''Ajout
Cl25m_Lignes = Cl25m_DataSet.Tables("Tireurs").NewRow()
Cl25m_Lignes("T_Nom") = Me.txtNom.Text
Cl25m_DataSet.Tables("Tireurs").Rows.Add(Cl25m_Lignes)
MONCommandBuilder = New OleDbCommandBuilder(Cl25m_DataAdapter)
Cl25m_DataSet.Clear()
Cl25m_DataAdapter.Fill(Cl25m_DataSet, "Tireurs")
Cl25m_DataTable = Cl25m_DataSet.Tables("Tireurs")
Partager