nickg21 0 Newbie Poster

Hey everyone,
I am lost on the exception that I have getting thrown at me right now.

SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

What I am trying to do on my site, which is Windows Authenticated on an internal network, is capture the users ID that is logged in, and then depending on which page(s) the user clicks, store them in a database.

This is the code to check if the users ID has been set, and to add the entry into the database via a parameterized query.

Initial Setting of Session for the UsersID

Dim LoggedIn As String = User.Identity.Name
        If LoggedIn.Contains("PARTNERS") Then
            Session("LoggedIn") = LoggedIn.Substring(9)
        Else
            Session("LoggedIn") = LoggedIn
        End If

Afterwards the user can either go into an "Edit.aspx" page or "View.aspx" page.
Depending on which page they choose, I want to store that in a database that I have called tblView. HEre is the structure of the table.

ID : Integer : Primary Key, auto-incremented
InquiryID_fk : Integer : Foreign Key; the inquiry id that is being viewed or edited
Page : Varchar(10) : Will store either "View" or "Edit" depending on the page entered
User : varchar(10) : Stores the userID : which is a max of 6 characters
Date : Date : Want to store the system date
Time : Time(7) : want to store the system time

Here is the code in the "View" page to store into the db, which throws the error

Dim InquiryID As String = Request.QueryString("id")
        Dim InquirySQL As String
        Session("InquiryID") = InquiryID
        If Not Session("LoggedIn") Is Nothing Then
            Dim ViewSQL As String
            ViewSQL = "Insert into tblView(InquiryID_fk, Page, User, Date, Time)Values(@InqID, @Page, @User, @ActDate, @ActTime)"
            Dim querycommand As New SqlCommand
            querycommand.Connection = Conn
            With querycommand
                .CommandType = CommandType.Text
                .CommandText = ViewSQL
                .Parameters.AddWithValue("@InqID", Session("InquiryID"))
                .Parameters.AddWithValue("@Page", "View")
                .Parameters.AddWithValue("@User", Session("LoggedIn"))
                .Parameters.AddWithValue("@ActDate", Date.Today)
                .Parameters.AddWithValue("@ActTime", TimeOfDay)
                Conn.Open()
                .ExecuteScalar()
                Conn.Close()
            End With
            querycommand.Dispose()
        End If

When I debug and put break points throughout the code, as well as after the error is thrown and i just highlight over the "Date.Today" or "TimeOfDay" variables, they are displaying the proper date and time from my machine. Does this mean they are out of sync with my server, running SQL Server 2008?

Any help would be excellent, this has been pretty frustrating.
Thank you in advance,
NickG

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.