hi,
I have an application vb2005 SQL Server 2005 Express Edition. I want the code to Listre records between two dates.
I use two DateTimePicker for research.
the field (date_traitement) is smalldatetime.
voila my code search:
Dim adp As New SqlDataAdapter ( "SELECT n_dossier as N_Dossier, date_traitement as Date_Traitement, nom_prenom as Nom_Prénom from T_traitement where [date_traitement] between" date1.Value & & " 'and" date2.Value & & "'", con)
but it not it displays the following error:
"The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value."
thank you in advance.
I have an application vb2005 SQL Server 2005 Express Edition. I want the code to Listre records between two dates.
I use two DateTimePicker for research.
the field (date_traitement) is smalldatetime.
voila my code search:
Dim adp As New SqlDataAdapter ( "SELECT n_dossier as N_Dossier, date_traitement as Date_Traitement, nom_prenom as Nom_Prénom from T_traitement where [date_traitement] between" date1.Value & & " 'and" date2.Value & & "'", con)
but it not it displays the following error:
"The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value."
thank you in advance.