Private Sub Chargecombobox() txtDocteur.Items.Clear() Using cmd As New OleDbCommand("SELECT * FROM PRATICIENS", con) Try con.Open() rd = cmd.ExecuteReader While rd.Read txtDocteur.Items.Add(rd(0)) End While con.Close() Catch ex As Exception ' en cas d'erreur après appui sur enter, affichage d'un message messageaff = "An error occurred during the reading access of the customers'list." infoaff = "Error Database access" MessageBox.Show(messageaff, infoaff, MessageBoxButtons.OK, MessageBoxIcon.Warning) End Try End Using End Sub
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionwc.DownloadFile(uri, localFileName) MoveFile(uri, newPath, wc.Credentials)
For Each filename In fileNames?
Private Sub download() Dim user As String = "monlogin" Dim password As String = "monpassword" Dim wc As New WebClient() wc.Credentials = New NetworkCredential(user, password) Dim baseUri = "ftp://ftp.cluster002.ovh.net/www/jdownloads/monchemin/" 'URI et chemin ou je veux aller dans le ftp Dim newDirectory As String = "../done_treatment/" Dim fileNames = GetDirectoryListing(baseUri, wc.Credentials) Dim localpath As String = "\\monnas\monchemin\" 'chemin ou je veux dl les fichiers For Each filename In fileNames Try Dim newPath As String = newDirectory + "/" + filename If Not filename.EndsWith(".xls", StringComparison.CurrentCultureIgnoreCase) Then 'ne tient pas compte de la casse Continue For End If Dim localFileName = System.IO.Path.Combine(localpath, filename) Dim uri = baseUri + "/" + filename wc.DownloadFile(uri, localFileName) MoveFile(uri, newPath, wc.Credentials) ' transfere le fichier dans done_treatment apres avoir downloade Catch ex As WebException Select Case ex.Status Case WebExceptionStatus.Timeout MessageBox.Show("Délai de connection expiré") Case WebExceptionStatus.NameResolutionFailure MessageBox.Show("Impossible de résoudre le nom") End Select End try Next System.Threading.Thread.Sleep(1000) Labelprogress.Visible = False OvalShapeencours.Visible = False Labeldone.Visible = True OvalShapedone.Visible = True Me.Enabled = True End Sub
Private Shared Function GetDirectoryListing(ByVal uri As String, ByVal credentials As ICredentials) As IList(Of String) Dim entries As New List(Of String)() Dim request = DirectCast(WebRequest.Create(uri), FtpWebRequest) If credentials IsNot Nothing Then request.Credentials = credentials End If request.Method = WebRequestMethods.Ftp.ListDirectory try Using response = DirectCast(request.GetResponse(), FtpWebResponse), stream = response.GetResponseStream(), reader = New StreamReader(stream) Dim line As String = reader.ReadLine() While line IsNot Nothing entries.Add(line) line = reader.ReadLine() End While Return entries Catch ex As webexception (mais la je ne sais pas trop quoi mettre) end try End Using End Function
Private Sub download() Dim user As String = "monlogin" Dim password As String = "monpassword" Dim wc As New WebClient() wc.Credentials = New NetworkCredential(user, password) Dim baseUri = "ftp://ftp.cluster002.ovh.net/www/jdownloads/monchemin/" 'URI et chemin ou je veux aller dans le ftp Dim newDirectory As String = "../done_treatment/" Dim fileNames = GetDirectoryListing(baseUri, wc.Credentials) Dim localpath As String = "\\monnas\monchemin\" 'chemin ou je veux dl les fichiers For Each filename In fileNames System.Threading.Thread.Sleep(1000) Try Dim newPath As String = newDirectory + "/" + filename If Not filename.EndsWith(".xls", StringComparison.CurrentCultureIgnoreCase) Then 'ne tient pas compte de la casse Continue For End If Dim localFileName = System.IO.Path.Combine(localpath, filename) Dim uri = baseUri + "/" + filename wc.DownloadFile(uri, localFileName) Catch ex As WebException Select Case ex.Status Case WebExceptionStatus.Timeout MessageBox.Show("Délai de connection expiré") End Select End try Next MoveFile(uri, newPath, wc.Credentials) ' transfere le fichier dans done_treatment apres avoir downloade Me.Enabled = True End Sub
Dim newPath As String = newDirectory + "/" + filename
Private Sub download() Dim user As String = "monlogin" Dim password As String = "monpassword" Dim wc As New WebClient() wc.Credentials = New NetworkCredential(user, password) Dim baseUri = "ftp://ftp.cluster002.ovh.net/www/jdownloads/monchemin/" 'URI et chemin ou je veux aller dans le ftp Dim newDirectory As String = "../done_treatment/" Dim fileNames = GetDirectoryListing(baseUri, wc.Credentials) Dim localpath As String = "\\monnas\monchemin\" 'chemin ou je veux dl les fichiers For Each filename In fileNames System.Threading.Thread.Sleep(1000) Try Dim newPath As String = newDirectory + "/" + filename If Not filename.EndsWith(".xls", StringComparison.CurrentCultureIgnoreCase) Then 'ne tient pas compte de la casse Continue For End If Dim localFileName = System.IO.Path.Combine(localpath, filename) Dim uri = baseUri + "/" + filename wc.DownloadFile(uri, localFileName) MoveFile(uri, newPath, wc.Credentials) ' transfere le fichier dans done_treatment apres avoir downloade Catch ex As WebException Select Case ex.Status Case WebExceptionStatus.Timeout MessageBox.Show("Délai de connection expiré") End Select End try Next Me.Enabled = True End Sub
Private Sub download() Dim erreur As Boolean Dim user As String = "monlogin" Dim password As String = "monpassword" Dim wc As New WebClient() Dim baseUri = "ftp://ftp.cluster002.ovh.net/www/jdownloads/monchemin/" 'URI et chemin ou je veux aller dans le ftp Dim newDirectory As String = "../done_treatment/" Dim fileNames As List(Of String) Dim localpath As String = "\\monnas\monchemin\" 'chemin ou je veux dl les fichiers ' Importation de la liste des fichiers depuis le serveur FTP Try wc.Credentials = New NetworkCredential(user, password) Dim request = DirectCast(WebRequest.Create(baseUri), FtpWebRequest) If wc.credentials IsNot Nothing Then request.Credentials = wc.credentials request.Method = WebRequestMethods.Ftp.ListDirectory Using response = DirectCast(request.GetResponse(), FtpWebResponse) ' attention il y avait une virgule bizarre stream = response.GetResponseStream() ' attention il y avait une virgule bizarre là aussi reader = New StreamReader(stream) Dim line As String = reader.ReadLine() While line IsNot Nothing fileNames.Add(line) line = reader.ReadLine() End While End Using erreur = False Catch ex As Exception MessageBox.Show("Erreur " & ex.ToString & " lors de l'importation de la liste des fichiers") erreur = True End Try If erreur = True Then Exit Sub ' la liste n'a pas été téléchargée : on quitte ' Télechargement des fichiers depuis le serveur FTP If fileNames.Count > 0 Then ' si la liste n'est pas vide For Each filename In fileNames If filename.EndsWith(".xls", StringComparison.CurrentCultureIgnoreCase) Then 'ne tient pas compte de la casse ' c'est un fichier .xls ----> on essaie de le télécharger Do Application.DoEvents() Try Dim localFileName = System.IO.Path.Combine(localpath, filename) Dim uri = baseUri + "/" + filename wc.DownloadFile(uri, localFileName) Dim newFile As String = newDirectory + "/" + filename System.Threading.Thread.Sleep(1000) MoveFile(uri, newFile, wc.Credentials) ' transfere le fichier dans done_treatment apres l'avoir téléchargé erreur = False Catch ex As Exception MessageBox.Show("Erreur " & ex.ToString & " lors du téléchargement du fichier" & filename) erreur = True End Try If erreur = True Then ' erreur : on propose de retélécharger à nouveau Dim Reponse As Integer = MessageBox.Show("Voulez-vous retenter le téléchargement du fichier " & filename, "Attention", MessageBoxButtons.YesNo, MessageBoxIcon.Question) If Reponse = DialogResult.No Then Exit Do ' on réponds non alors on sort et on téléchargele fichier suivant si il y a lieu End If Loop End If Next Else MessageBox.Show("Aucun fichier à télécharger : la liste sur le serveur est vide") End If End Sub