Problem reading datetime values

eresina · February 5th, 2005, 12:51 PM

Hello,

I have a SqlServer database from where I display information in a asp.net page. I'm having problems reading a datetime column. Below, I show you my code. Please, if someone have a hint, don't be shy a tell me:)

Code:

        Dim format As New System.Globalization.CultureInfo("pt-PT", True)
        Thread.CurrentThread.CurrentCulture = New System.Globalization.CultureInfo("pt-PT", True)

        SqlConFuncionarios.Open()
        Dim Novadata1 As String = Session("IS") & " 00:00:00"
        Dim INSEMANA As DateTime = System.DateTime.Parse(Novadata1, format, System.Globalization.DateTimeStyles.AllowLeadingWhite)
        Dim Novadata2 As String = Session("FS") & " 00:00:00"
        str1 = "SELECT  cod_fucnionario ,Fhoras_Data,Cod_Tipo_movimento,Hora ,minuto FROM FhoraS_Horas WHERE Cod_fucnionario = " & Session("cod_fun") & "  And ( fhoras_data >= '" & Session("IS") & "' and  fhoras_data <= '" & Session("FS") & "')  ORDER BY Fhoras_Data   asc"
        'str1 = "SELECT  cod_fucnionario ,Fhoras_Data,Cod_Tipo_movimento,Hora ,minuto FROM FhoraS_Horas WHERE (Cod_fucnionario = " & Session("cod_fun") & ")  And (fhoras_data BETWEEN CONVERT(DATETIME," & Session("IS") & " 00:00:00,102) and CONVERT(DATETIME," & Session("FS") & " 00:00:00,102)) ORDER BY Fhoras_Data asc"
        SqlCom1 = New SqlClient.SqlCommand(str1, SqlConFuncionarios)
        MydataReader1 = SqlCom1.ExecuteReader(CommandBehavior.CloseConnection)
        MydataReader1.Read()
        If MydataReader1.HasRows Then
            Do  'avanÃ§a com o datareader atÃ© ao proximo registo
                DataDia = MydataReader1.GetValue(1)
...

end if
MydataReader1.Close()

thanks

Elisa

Elisa Resina