Dim laconnection$ = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Nom_dossier$ & ";Extended Properties=" & Chr(34) & "text;HDR=Yes;FMT=Delimited(,)" & Chr(34) Dim textConnection = New System.Data.OleDb.OleDbConnection(laconnection$) textConnection.open() dim DatatoLoad As DataSet chemin_fichier$ = New System.IO.FileInfo(chemin_fichier$).Name Dim selectCommand$ = "select " & critere1$ & " from " & chemin_fichier$ & critere2$ Dim textOpenCommand = New System.Data.OleDb.OleDbCommand(selectCommand$) textOpenCommand.Connection = textConnection Dim textDataAdapter = New System.Data.OleDb.OleDbDataAdapter(textOpenCommand) Dim enregistrements = textDataAdapter.Fill(DatatoLoad) dim Nombre_Trouvé as long = DatatoLoad.Tables(0).Rows.Count.ToString textConnection.Close() textConnection.Dispose()
Option Strict On Option Explicit On Imports System.Data.OleDb Public Class Form1 Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim ConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=c:\;" & _ "Extended Properties=""text;HDR=Yes;FMT=Delimited""" Dim SQL As String = "SELECT MIN(DateDeb), MAX(DateDeb) FROM `a.csv`" Dim DataAdapter As OleDbDataAdapter = New OleDbDataAdapter(SQL, ConnectionString) Dim Data As New DataSet() DataAdapter.Fill(Data) With Data.Tables(0).Rows(0) MessageBox.Show(.Item(0).ToString() & " " & .Item(1).ToString()) End With End Sub End Class
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question