Public Function Find_Con_Date(ByVal on_rech_date.value As String) As DataTable
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionPublic Function Find_Con_Date(ByVal Date_jour As String) As DataTable Dim Cmd As New OleDbCommand Dim Datab As New DataTable Try Cmd.CommandText "select * from Connection where Date_jour" & Date_jour.ToString
Datab = Con.Select_DataTable(Cmd) Catch ex As Exception MsgBox(ex.Message & " Find_Con_Date()") End Try Return Datab End Function
Private Sub con_b_rech_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles con_b_rech.Click Dim i As Int16 Dim Date_jour As String Dim dt As New DataTable i = dacces.Find_Con_Date(Date_jour as string)as System.Data.DataTable If i > 0 Then MsgBox("OK") Me.ConnectionDataGridView.DataSource = dacces.Find_Con_Date(Me.con_rech_date.Value) End If End Sub
et le bouton rechercher je mets ce code la?
Dim i As Int16 Dim Date_jour As String Dim dt As New DataTable i = dacces.Find_Con_Date(Date_jour) If i > 0 Then MsgBox("OK") Me.ConnectionDataGridView.DataSource = dacces.Find_Con_Date(Me.con_rech_date.Value) End If
dacces.Find_Con_Date(Date_jour)
Dim i As Int16 ' Tu déclare ici une valeur de type short (Integer 16) Dim Date_jour As String' Tu déclare la une variable qui ne sert à rien... Dim dt As New DataTable' Et ici une datatable i = dacces.Find_Con_Date(Date_jour)' Le problème est bien la 'Find_Con_Date retourne un DataTable et non un Short. Le mieu c'est de ne garder que : Me.ConnectionDataGridView.DataSource = dacces.Find_Con_Date(Me.con_rech_date.Value)
Public Class Connection Dim MaConnection As OleDbConnection = New OleDbConnection Dim Adapter As OleDbDataAdapter = New OleDbDataAdapter Dim ChaineConnection As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=|DataDirectory|\CyberDB.mdb" & ";" & _ "Persist Security Info=False" Public Function Select_DataTable(ByVal Cmd As OleDbCommand) As DataTable Dim dt As New DataTable Try MaConnection.Close() MaConnection.ConnectionString = ChaineConnection MaConnection.Open() If MaConnection.State = ConnectionState.Open Then Cmd.Connection = MaConnection Adapter.SelectCommand = Cmd ' dt = New DataTable Adapter.Fill(dt) Else MsgBox("Connexion failed...") End If Catch ex As Exception MsgBox(ex.Message & " Select_DataTable") End Try Return dt End Function Public Function Mise_A_Jour(ByVal Cmd As OleDbCommand) As Integer Dim i As Integer MaConnection.Close() MaConnection.ConnectionString = ChaineConnection MaConnection.Open() Cmd.Connection = MaConnection i = Cmd.ExecuteNonQuery() Return i End Function End Class
Me.ConnectionDataGridView.DataSource = dacces.Find_Con_Date(Me.con_rech_date.Value.Date.Date)