Asp. NET error message: At least one parameter is not assigned a value

Asp.net| Error

A server error in the "/website1" application.
--------------------------------------------------------------------------------

At least one parameter is not assigned a value.
Note: An unhandled exception occurred during the execution of the current WEB request. Check the stack trace for more information about the error and where the error occurred in the code.

Exception Details: System.Data.OleDb.OleDbException: At least one parameter is not assigned a value.

SOURCE Error:

Row 41:sql_update = "Update Rizhi set rq= '" & RQ & "', je=" & JE & ", [title]= '" & Title1 & " ', content= ' & content & ' where id= ' & ID
Row 42:mycommand = New OleDbCommand (sql_update, conn)
Row 43:j = mycommand. ExecuteNonQuery ()
Line 44:mycommand. Dispose ()
Line 45:conn. Close ()

Source file: E:\asp.net\Visual Studio 2005\websites\website1\rizhi_edit.aspx Line: 43

Stack trace:

[OleDbException (0X80040E10): At least one parameter is not assigned a value. ]
System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult (Tagdbparams dbparams, object& executeresult) +177
System.Data.OleDb.OleDbCommand.ExecuteCommandText (object& executeresult) +194
System.Data.OleDb.OleDbCommand.ExecuteCommand (CommandBehavior behavior, object& executeresult) +56
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal (CommandBehavior behavior, String method) +105
System.Data.OleDb.OleDbCommand.ExecuteNonQuery () +88
ASP.rizhi_edit_aspx.submit (Object o, EventArgs e) in e:\asp.net\Visual Studio 2005\websites\website1\rizhi_edit.aspx : 43
System.Web.UI.WebControls.Button.OnClick (EventArgs e) +75
System.Web.UI.WebControls.Button.RaisePostBackEvent (String eventargument) +97
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent (String eventargument) +7
System.Web.UI.Page.RaisePostBackEvent (IPostBackEventHandler sourcecontrol, String eventargument) +11
System.Web.UI.Page.RaisePostBackEvent (NameValueCollection postdata) +33
System.Web.UI.Page.ProcessRequestMain (Boolean includestagesbeforeasyncpoint, Boolean includestagesafterasyncpoint ) +4919

--------------------------------------------------------------------------------
Version information: Microsoft. NET Framework Version: 2.0.50727.42; asp.net version: 2.0.50727.42

This error is typically caused by an SQL statement, such as the

Row 41:sql_update = "Update Rizhi set rq= '" & RQ & "', je=" & JE & ", [title]= '" & Title1 & " ', content= ' & content & ' where id= ' & ID

is because the field N_je mistakenly written je, and caused the error.