SELECT * FROM [Table] WHERE [MaDate] > #YYYY-MM-DD#
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionDim MyConnexion As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Projet de mise a jour\Basededonnées\Edson80.mdb;Jet OLEDB:System Database=system.mdw;") 'Définition de la connexion Dim Mycommand1 As OleDbCommand = MyConnexion.CreateCommand() 'générer la connexion Mycommand1.CommandText = " SELECT Fi_Bordereau.F_numbord, Fi_Bordereau.F_numclib, " & _ " Fi_Bordereau.F_nomclib, Fi_Bordereau.F_prenclib, " & _ "Fi_Bordereau.F_libelPb, Fi_Bordereau.F_coutPb, " & _ "Fi_Bordereau.F_partnonAPb, Fi_Bordereau.F_partAssrPb," & _ " Fi_Bordereau.F_NomTierceb, Fi_Bordereau.F_ModeRgltb, Fi_Bordereau.F_Dateb " & _ "FROM Fi_Bordereau " & _ " WHERE (((Fi_Bordereau.F_partnonAPb)<>0) AND ((Fi_Bordereau.F_Dateb) Between #" & TextBoxperiodedebut.Text & "# And #" & TextBoxperiodefin.Text & "#) AND ((Fi_Bordereau.F_numopb)=" & ComboCaisseop.Text & "));" MyConnexion.Open() Dim ColN0 As String 'déclarer un ensemble de ligne Dim ColN1 As String 'déclarer un ensemble de ligne Dim ColN2 As String 'déclarer un ensemble de ligne Dim ColN3 As String 'déclarer un ensemble de ligne Dim ColN4 As String 'déclarer un ensemble de ligne Dim ColN5 As String 'déclarer un ensemble de ligne Dim ColN6 As String 'déclarer un ensemble de ligne Dim ColN7 As String 'déclarer un ensemble de ligne Dim ColN8 As String 'déclarer un ensemble de ligne Dim ColN9 As String 'déclarer un ensemble de ligne Dim ColN10 As String 'déclarer un ensemble de ligne Dim myReaderNA As OleDbDataReader = Mycommand1.ExecuteReader() '----------------- Recherche de la donnée ---------------- Do While myReaderNA.Read() ColN0 = myReaderNA.GetString(0) 'affiche la rubrique lue dans la zone liste ColN1 = myReaderNA.GetString(1) ColN2 = myReaderNA.GetString(2) ColN3 = myReaderNA.GetString(3) ColN4 = myReaderNA.GetString(4) ColN5 = myReaderNA.GetValue(5).ToString ColN6 = myReaderNA.GetValue(6).ToString ColN7 = myReaderNA.GetValue(7).ToString ColN8 = myReaderNA.GetString(8) ColN9 = myReaderNA.GetString(9) ColN10 = myReaderNA.GetDateTime(10).ToShortDateString Me.DataGridViewNAssure.Rows.Add(ColN0, ColN1, ColN2, ColN3, ColN4, ColN5, ColN6, ColN7, ColN8, ColN9, ColN10)
"SELECT F_numbord, F_numclib, F_nomclib, F_prenclib, F_libelPb, F_coutPb, F_partnonAPb, F_partAssrPb, F_NomTierceb, F_ModeRgltb, F_Dateb " & _ "FROM Fi_Bordereau " & _ "WHERE F_partnonAPb <>0 AND " & _ " F_numopb='" & ComboCaisseop.Text & "' AND " & _ " F_Dateb BETWEEN #" & TextBoxperiodedebut.Text & "# AND #" & TextBoxperiodefin.Text & "# "
Format specifier
Name
Description
Examples
"C" or "c"
Currency
Result: A currency value.
Supported by: All numeric types.
Precision specifier: Number of decimal digits.
Default precision specifier: Defined by System.Globalization.NumberFormatInfo.
More information: The Currency ("C") Format Specifier.
123.456 ("C", en-US) -> $123.46
123.456 ("C", fr-FR) -> 123,46 €
123.456 ("C", ja-JP) -> ¥123
-123.456 ("C3", en-US) -> ($123.456)
-123.456 ("C3", fr-FR) -> -123,456 €
-123.456 ("C3", ja-JP) -> -¥123.456