I have a little online form that accepts an employee's first and last name and their selection of a class time from a dropdown.
On submit, the form adds a new record to the "employee" table with the employee first and last name and then updates the "classList" table, adding one to the number of students registered to the class selected (since each class can only have 25 students). It is an Access 2003 database.
The problem is the database hangs up. Somewhere in my code, I am not properly closing the connection. Needless to say, when enough people hit the database, it causes big problems on the server.
I really need help!! Thanks in advance.
Here is my code:
If Page.IsValid Then
        Dim objConn As New OleDbConnection(sConnStr)
        Dim strFName, strLName As String
        Dim intID As Integer

        strFName = txtFName.Text
        strLName = txtLName.Text
        intID = ddlClasses.SelectedItem.Value
        Dim clID As New OleDbParameter("@clID", OleDbType.Integer)
        clID.Value = intID

        strSQL = New System.Text.StringBuilder()

        strSQL.Append("INSERT INTO employees (FName, LName, Class_ID) VALUES ('" & txtFName.Text & "','" & txtLName.Text & "', '" & intID & "' )")
        Dim objCommand As New OleDbCommand(strSQL.ToString, objConn)
        objConn.Open()

        objCommand.ExecuteNonQuery()

        strSQL = New System.Text.StringBuilder()
        strSQL.Append("UPDATE classList SET studentCt = studentCt + 1 WHERE Class_ID = " & intID & " ")
        objCommand = New OleDbCommand(strSQL.ToString, objConn)
        lblTest.Text = strSQL.ToString
        objCommand.ExecuteNonQuery()
        objConn.Close()
        objConn = Nothing

        lblThanks.Visible = True
        btnSubmit.Visible = False

      End If

Hi,
Can you be a bit more specific as to which line of code causes the exception. Try stepping through the code to see which line throws you out.
Just as a quick thought though, you have put single quotes around 'intID' in the INSERT INTO string. This could be causing a problem when the database is expecting an Integer Value for the Field, not a String.


____________________________
multi-tasking - the ability to hang more than one app. at the same time.

Never mind! I found the problem in another part of the code