Dim i As Long Dim oleDbConnex As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data source=C:\Documents and Settings\nicolas_larue\Mes documents\DéploiementDeSynoptiques\BDD.mdb") oleDbConnex.Open() Dim CmdIP As New OleDb.OleDbCommand("SELECT AdresseIP FROM Machine WHERE NomMachine = '" & LB_ListeMachines.Items(i) & "' ", oleDbConnex) Dim TA1 As New OleDb.OleDbDataAdapter(CmdIP) TA1.Fill(DT) Dim var As String 'Dim IP As String For i = 0 To LB_ListeMachines.Items.Count - 1 'IP = DT.Rows(i)("AdresseIP").ToString() var = "\" & DT.Rows(i)("AdresseIP").ToString() & "\ia" Dim DestDir As String = var MessageBox.Show("SELECT AdresseIP FROM Machine WHERE NomMachine = '" & LB_ListeMachines.Items(i) & "' ") MessageBox.Show(var) Try For Each Item As String In LB_ListeFichier.Items Try Dim Filename As String = Item.Substring(Item.LastIndexOf(""), Item.Length - Item.LastIndexOf("")) IO.File.Copy(Item, DestDir & Filename) Application.DoEvents() 'Evite le Freez de l'appli Catch copyError As IOException MessageBox.Show("Erreur pour la copie des fichiers ! " & copyError.Message) End Try Next Catch dirNotFound As DirectoryNotFoundException MessageBox.Show(" Erreur de copie ! " & dirNotFound.Message) End Try Next i oleDbConnex.Close()
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionFor i = 1 To TA1.TableMappings.Count ' à vérifier ... MessageBox.Show(DT.Rows(i)("NomMachine").ToString()) MessageBox.Show(var)