R_enregistrement = _ "SELECT date1 as [Date], " & _ " date1 as [Heure début], " & _ " date2 as [Heure fin], " & _ " Veille, " & _ " DATEDIFF([date2],[date1]) as [Temps travail], " & _ " DATEDIFF([date2],[date1]) as [Temps total] " & _ " FROM temps"
Public Sub DGV() ds.Clear() Dim R_enregistrement As String R_enregistrement = _ "SELECT date1 as [Date], " & _ "date1 as [Heure début]," & _ "date2 as [Heure fin]," & _ "Veille," & _ "DATEDIFF(s,[date2],[date1]) as [Temps travail]," & _ "DATEDIFF(s,[date2],[date1]) as [Temps total] " & _ "FROM temps" cmd = New OleDbCommand(R_enregistrement) da = New OleDbDataAdapter(cmd) cmd.Connection = con da.Fill(ds, "temps") dt = ds.Tables("temps") Form_Historique.DGV_E.DataSource = dt End Sub
da = New OleDbDataAdapter(cmd)
da = New OleDbDataAdapter(R_enregistrement)
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questioncmd = New OleDbCommand(R_enregistrement) da = New OleDbDataAdapter(cmd) cmd.Connection = con da.Fill(ds, "temps") dt = ds.Tables("temps") Form_Historique.DGV_E.DataSource = dt
Public Sub DGV() ds.Clear() Dim cmd As New OleDb.OleDbCommand Dim R_enr As String R_enr = "SELECT date1 as [Date], " & _ "date1 as [Heure début]," & _ "date2 as [Heure fin]," & _ "Veille," & _ "date2-date1 as [Temps total] " & _ "FROM temps" cmd = New OleDb.OleDbCommand(R_enr, con) cmd.Connection.Open() Dim da As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter da.SelectCommand = cmd da.Fill(ds, "temps") dt = ds.Tables("temps") Form_Historique.DGV_E.DataSource = dt cmd.Connection.Close() End Sub
Dim cmd As OleDb.OleDbCommand Dim sql_ajouter = "INSERT INTO Temps (Date1, Date2, Veille) VALUES(Val_Date1, Val_Date2, Val_Veille)" cmd = New OleDb.OleDbCommand(sql_ajouter, con) cmd.Parameters.AddWithValue("Val_Date1", date1.ToString) cmd.Parameters.AddWithValue("Val_date2", date2.ToString) cmd.Parameters.AddWithValue("Val_Veille", veille) cmd.Connection.Open() cmd.ExecuteReader() cmd.Connection.Close() DGV()