Create sample standalone forum similar to jitbit,

[swornavidhya_m]

Hai, I've provided with jitbit software to configure a forum newly for our existing website, and the forum must look like jitbit forum. My boss asked to create a sample standalone forum, which looks like jitbit forum. I've created the virtual directory called forum in my local computer's iis, and configured it with iis of my system. I'm able to get my virtual directory run in my browser. The thing is that, when doing any operation like registering an user newly / logged in as admin with given password and when signout operation is triggered.. I am receiving the following error :

Operation must use an updateable query.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: Operation must use an updateable query.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[OleDbException (0x80004005): Operation must use an updateable query.]
System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) +1002416
System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) +255
System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +188
System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +58
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +161
System.Data.OleDb.OleDbCommand.ExecuteNonQuery() +113
aspnetforum.Utils.User.UpdateLastLogonDate(Int32 userId) +208
aspnetforum.ForumPage.OnInit(EventArgs e) +1686
System.Web.UI.Control.InitRecursive(Control namingContainer) +333
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +378

Version Information: Microsoft .NET Framework Version:2.0.50727.3053; ASP.NET Version:2.0.50727.3053

I don't know how to proceed further. My task is to create a forum which looks similar like jitbit forum. Help needed regarding this. Regards, M.Sworna Vidhya

[JHizzle]

swornavidhya_m wrote:

My task is to create a forum which looks similar like jitbit forum

I think we got it the first time. Please provide the code around where it is updating the database with the last logon date because that's apparently where it is going wrong. Specifically your insert/update statement appears to have an issue with it but I can't tell anything else without seeing it.