getdate Not Working

~Bean~ · July 15th, 2005, 09:55 AM

I have a table with a datetime field with default value set to (getdate()) but when I insert a record from my ASP.NET page it doesn't put anything in the field (leaves it null). If I change the option for "Allow nulls" I get an error...

???

-------------------------
Beware of programmers with screwdrivers...

jbenson001 · July 15th, 2005, 01:58 PM

can you post your ASP.NET code?

~Bean~ · July 15th, 2005, 02:10 PM

Dim objConn As SqlConnection
        Dim objAdapter As SqlDataAdapter
        ' Dim objTable As DataTable
        Dim objNewRow As DataRow
        Dim objBuilder As SqlCommandBuilder

        objConn = New SqlConnection(m_connString)
        objAdapter = New SqlDataAdapter("Select * from tblExam", objConn)
        objAdapter.FillSchema(m_Dataset, SchemaType.Source)
        objNewRow = m_Dataset.Tables(0).NewRow()
        objNewRow.Item("Name") = m_ExamName
        objNewRow.Item("IDP") = m_IDP
    m_Dataset.Tables(0).Rows.Add(objNewRow)
        objBuilder = New SqlCommandBuilder(objAdapter)
        objAdapter.InsertCommand = objBuilder.GetInsertCommand
        objAdapter.UpdateCommand = objBuilder.GetUpdateCommand
        If objAdapter.Update(m_Dataset.Tables(0)) >= 1 Then
            Return 1
        Else
            Return 0
        End If

-------------------------
Beware of programmers with screwdrivers...

robprell · September 7th, 2005, 08:24 PM

I think dot net helps your by thinking you forgot to send a value and thus sends a null. What happens if you set the table to not allow nulls. I believe the problem is on the dot net side of things. Question is how to get dot net to not help you I believe.

jbenson001 · September 7th, 2005, 11:31 PM

Can you post the code for objBuilder.GetInsertCommand?