Error: "System.Data.OleDb.OleDbException: No value given for one or more required par

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • AlsonToh
    New Member
    • Jul 2010
    • 1

    Error: "System.Data.OleDb.OleDbException: No value given for one or more required par

    No value given for one or more required parameters.
    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.Ole Db.OleDbExcepti on: No value given for one or more required parameters.

    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:

    Code:
    [OleDbException (0x80040e10): No value given for one or more required parameters.]
       System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) +1006560
       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
       System.Web.UI.WebControls.SqlDataSourceView.ExecuteDbCommand(DbCommand command, DataSourceOperation operation) +386
       System.Web.UI.WebControls.SqlDataSourceView.ExecuteDelete(IDictionary keys, IDictionary oldValues) +303
       System.Web.UI.DataSourceView.Delete(IDictionary keys, IDictionary oldValues, DataSourceViewOperationCallback callback) +89
       System.Web.UI.WebControls.GridView.HandleDelete(GridViewRow row, Int32 rowIndex) +714
       System.Web.UI.WebControls.GridView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup) +869
       System.Web.UI.WebControls.GridView.RaisePostBackEvent(String eventArgument) +207
       System.Web.UI.WebControls.GridView.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
       System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
       System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +175
       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565
    Version Information: Microsoft .NET Framework Version:2.0.507 27.4927; ASP.NET Version:2.0.507 27.4927
  • Frinavale
    Recognized Expert Expert
    • Oct 2006
    • 9749

    #2
    Well, according to this error message you are not providing all of the data required for the database query.

    -Frinny

    Comment

    Working...