Quiz results to a database using asp.net

Hi Kwame_za,

If you're using an MS Access backend, you don't need a connection string in the web.config file.  The code behind file wsCaptivate.asmx.vb has the following method:

    Private Sub SendResultsToMsAccess()
        Dim sb As New StringBuilder
        Dim cn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data" + _
            " Source=c:\CaptivateLMSData.mdb;User Id=admin;Password=;")
        Dim cmd As New OleDbCommand

        'Build Insert Command
        sb.Append("INSERT INTO tblCaptivateLMSData " + _
         "(courseID,courseTitle,scoID,scoTitle,Email,RawScore,MaxScore,MinScore,LMSStatus," + _
         "LMSLocation,LMSTime,LMSSuspendData,LMSInteractions) " + _
        "VALUES (@courseID,@courseTitle,@scoID,@scoTitle,@Email,@RawScore,@MaxScore,@MinScore,@LMSStatus," + _
        "@LMSLocation,@LMSTime,@LMSSuspendData,@LMSInteractions)")

        With cmd
            .Parameters.AddWithValue("courseID", _courseID)
            .Parameters.AddWithValue("courseTitle", _courseTitle)
            .Parameters.AddWithValue("scoID", _scoID)
            .Parameters.AddWithValue("scoTitle", _scoTitle)
            .Parameters.AddWithValue("Email", _Email)
            .Parameters.AddWithValue("RawScore", _RawScore)
            .Parameters.AddWithValue("MaxScore", _MaxScore)
            .Parameters.AddWithValue("MinScore", _MinScore)
            .Parameters.AddWithValue("LMSStatus", _LMSStatus)
            .Parameters.AddWithValue("LMSLocation", _LMSLocation)
            .Parameters.AddWithValue("LMSTime", _LMSTime)
            .Parameters.AddWithValue("LMSSuspendData", _LMSSuspendData)
            .Parameters.AddWithValue("LMSInteractions", _LMSInteractions)
            .CommandText = sb.ToString
            .Connection = cn
            .Connection.Open()
            .ExecuteNonQuery()
            .Connection.Close()
            .Dispose()
        End With

        cn.Dispose()

    End Sub

The cn object is your connection object wich is eventually disposed of.  However, you do need impersonation cut on in your web.config file with the credentials of a user that has read/write to the folder where the MS Access db is located.  Impersonation is already cut on in the web.config file, but you need to supply the credentials of an account with those rights.  Web.config Example:

    <!-- JBL: Cut on Impersonation so you can save Results to the MS Access DB in a
           Folder other than your web root for security reasons-->
        <identity impersonate="true" userName="YourDomain\YourUserName" password="YouPasswordHere"/>

Jim Leichliter

Hi there

Indeed I understood that when I provided the link. The hope was that by reviewing what was presented, you might deduce the steps needed to accomplish your goal. So where you see the reference to CF, you use the equivalent feature in asp.net.

To my knowledge there is no step-by-step tutorial for all the different database possibilities.

Cheers... Rick