Yes it is an access database.
There is no code, it was all put together with the detailsview smart-tag.
Jim
"Patrick.O.Ige" <> wrote in message
news:eKfBH$...
> Post some snippet code..
> Are you using MS Access?
> Patrick
>
> "Jim McGivney" <> wrote in message
> news:...
>> In asp 2.0 I am trying to insert a row using a detailsview control
>> connected to an accessDataSource. I get the error message below. I am
>> having trouble identifing which data field is causing the problem. Any
>> suggestings are welcomed.
>> Jim
>> *************
>> You tried to assign the Null value to a variable that is not a Variant
>> data type.
>> 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: You tried to assign
>> the Null value to a variable that is not a Variant data type.
>>
>> 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): You tried to assign the Null value to a
>> variable that is not a Variant data type.]
>>
>> System.Data.OleDb.OleDbCommand.ExecuteCommandTextF orSingleResult(tagDBPARAMS
>> dbParams, Object& executeResult) +177
>> System.Data.OleDb.OleDbCommand.ExecuteCommandText( Object&
>> executeResult) +194
>> System.Data.OleDb.OleDbCommand.ExecuteCommand(Comm andBehavior behavior,
>> Object& executeResult) +56
>> System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior
>> behavior, String method) +105
>> System.Data.OleDb.OleDbCommand.ExecuteNonQuery() +88
>> System.Web.UI.WebControls.SqlDataSourceView.Execut eDbCommand(DbCommand
>> command, DataSourceOperation operation) +392
>> System.Web.UI.WebControls.SqlDataSourceView.Execut eInsert(IDictionary
>> values) +403
>> System.Web.UI.DataSourceView.Insert(IDictionary values,
>> DataSourceViewOperationCallback callback) +68
>> System.Web.UI.WebControls.DetailsView.HandleInsert (String commandArg,
>> Boolean causesValidation) +390
>> System.Web.UI.WebControls.DetailsView.HandleEvent( EventArgs e, Boolean
>> causesValidation, String validationGroup) +609
>> System.Web.UI.WebControls.DetailsView.OnBubbleEven t(Object source,
>> EventArgs e) +87
>> System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
>> +35
>> System.Web.UI.WebControls.DetailsViewRow.OnBubbleE vent(Object source,
>> EventArgs e) +109
>> System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
>> +35
>> System.Web.UI.WebControls.LinkButton.OnCommand(Com mandEventArgs e) +86
>> System.Web.UI.WebControls.LinkButton.RaisePostBack Event(String
>> eventArgument) +153
>>
>> System.Web.UI.WebControls.LinkButton.System.Web.UI .IPostBackEventHandler.RaisePostBackEvent(String
>> eventArgument) +7
>> System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler
>> sourceControl, String eventArgument) +11
>> System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData)
>> +172
>> System.Web.UI.Page.ProcessRequestMain(Boolean
>> includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
>> +4921
>>
>>
>>
>> --------------------------------------------------------------------------------
>> Version Information: Microsoft .NET Framework Version:2.0.50727.42;
>> ASP.NET Version:2.0.50727.42
>>
>
>
|
Similar Threads
