Prev: Modify appSettings in wen.config file.
Next: AJAX calendar control
From: deneushasler on 2 Jul 2008 13:58
Hello my name is Juan Jose.
My problem is as follows. When I try to insert a record into a
table (access) to control DetailsView Visual Web Developer 2005,
when I run the page and insert a record pulse, whenever I get the
following error:

How could fix it?


[OleDbException (0x80004005): Ha intentado asignar el valor Null a una
variable que no es un tipo de datos Variant.]
System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult
hr) +65
System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS
dbParams, Object& executeResult) +181
System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
+307
System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior,
Object& executeResult) +77
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior
behavior, String method) +188
System.Data.OleDb.OleDbCommand.ExecuteNonQuery() +113
System.Web.UI.WebControls.SqlDataSourceView.ExecuteDbCommand(DbCommand
command, DataSourceOperation operation) +495
System.Web.UI.WebControls.SqlDataSourceView.ExecuteInsert(IDictionary
values) +557
System.Web.UI.DataSourceView.Insert(IDictionary values,
DataSourceViewOperationCallback callback) +173
System.Web.UI.WebControls.FormView.HandleInsert(String commandArg,
Boolean causesValidation) +627
System.Web.UI.WebControls.FormView.HandleEvent(EventArgs e, Boolean
causesValidation, String validationGroup) +745
System.Web.UI.WebControls.FormView.OnBubbleEvent(Object source, EventArgs
e) +163
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +56
System.Web.UI.WebControls.FormViewRow.OnBubbleEvent(Object source,
EventArgs e) +118
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +56
System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +107
System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String
eventArgument) +178
System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String
eventArgument) +31
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument) +32
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +244
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3837


From: David Wier on 2 Jul 2008 14:33
Just glancing, knowing very little spanish - could it be that you have what
you think is an autonumber field, but it's not set for autonumber, and
you're not supplying it with data, in your insert statement?

One way or the other, it looks like you've got no data for a field that does
not allow nulls


David Wier
http://aspnet101.com
http://iWritePro.com - One click PDF, convert .doc/.rtf/.txt to HTML with no
bloated markup


"deneushasler" <deneushasler(a)hotmail.com> wrote in message
news:ubvdN1G3IHA.2524(a)TK2MSFTNGP04.phx.gbl...
> Hello my name is Juan Jose.
> My problem is as follows. When I try to insert a record into a
> table (access) to control DetailsView Visual Web Developer 2005,
> when I run the page and insert a record pulse, whenever I get the
> following error:
>
> How could fix it?
>
>
> [OleDbException (0x80004005): Ha intentado asignar el valor Null a una
> variable que no es un tipo de datos Variant.]
>
> System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult
> hr) +65
>
> System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS
> dbParams, Object& executeResult) +181
> System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
> +307
> System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior,
> Object& executeResult) +77
> System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior
> behavior, String method) +188
> System.Data.OleDb.OleDbCommand.ExecuteNonQuery() +113
> System.Web.UI.WebControls.SqlDataSourceView.ExecuteDbCommand(DbCommand
> command, DataSourceOperation operation) +495
> System.Web.UI.WebControls.SqlDataSourceView.ExecuteInsert(IDictionary
> values) +557
> System.Web.UI.DataSourceView.Insert(IDictionary values,
> DataSourceViewOperationCallback callback) +173
> System.Web.UI.WebControls.FormView.HandleInsert(String commandArg,
> Boolean causesValidation) +627
> System.Web.UI.WebControls.FormView.HandleEvent(EventArgs e, Boolean
> causesValidation, String validationGroup) +745
> System.Web.UI.WebControls.FormView.OnBubbleEvent(Object source,
> EventArgs
> e) +163
> System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
> +56
> System.Web.UI.WebControls.FormViewRow.OnBubbleEvent(Object source,
> EventArgs e) +118
> System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
> +56
> System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +107
> System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String
> eventArgument) +178
>
> System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String
> eventArgument) +31
> System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
> sourceControl, String eventArgument) +32
> System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +244
> System.Web.UI.Page.ProcessRequestMain(Boolean
> includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3837
>
>


From: deneushasler on 3 Jul 2008 10:30
If there is an autonumber field as can be solved?





"deneushasler" <deneushasler(a)hotmail.com> escribi� en el mensaje de
noticias:ubvdN1G3IHA.2524(a)TK2MSFTNGP04.phx.gbl...
> Hello my name is Juan Jose.
> My problem is as follows. When I try to insert a record into a
> table (access) to control DetailsView Visual Web Developer 2005,
> when I run the page and insert a record pulse, whenever I get the
> following error:
>
> How could fix it?
>
>
> [OleDbException (0x80004005): Ha intentado asignar el valor Null a una
> variable que no es un tipo de datos Variant.]
>
> System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult
> hr) +65
>
> System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS
> dbParams, Object& executeResult) +181
> System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
> +307
> System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior,
> Object& executeResult) +77
> System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior
> behavior, String method) +188
> System.Data.OleDb.OleDbCommand.ExecuteNonQuery() +113
> System.Web.UI.WebControls.SqlDataSourceView.ExecuteDbCommand(DbCommand
> command, DataSourceOperation operation) +495
> System.Web.UI.WebControls.SqlDataSourceView.ExecuteInsert(IDictionary
> values) +557
> System.Web.UI.DataSourceView.Insert(IDictionary values,
> DataSourceViewOperationCallback callback) +173
> System.Web.UI.WebControls.FormView.HandleInsert(String commandArg,
> Boolean causesValidation) +627
> System.Web.UI.WebControls.FormView.HandleEvent(EventArgs e, Boolean
> causesValidation, String validationGroup) +745
> System.Web.UI.WebControls.FormView.OnBubbleEvent(Object source,
> EventArgs
> e) +163
> System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
> +56
> System.Web.UI.WebControls.FormViewRow.OnBubbleEvent(Object source,
> EventArgs e) +118
> System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
> +56
> System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +107
> System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String
> eventArgument) +178
>
> System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String
> eventArgument) +31
> System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
> sourceControl, String eventArgument) +32
> System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +244
> System.Web.UI.Page.ProcessRequestMain(Boolean
> includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3837
>
>
From: deneushasler on 3 Jul 2008 10:35
Hello, you could send me a project to insert records in fields with
autonumber, my mail is deneushasler(a)hotmail.com
Thank you





"deneushasler" <deneushasler(a)hotmail.com> escribi� en el mensaje de
noticias:ubvdN1G3IHA.2524(a)TK2MSFTNGP04.phx.gbl...
> Hello my name is Juan Jose.
> My problem is as follows. When I try to insert a record into a
> table (access) to control DetailsView Visual Web Developer 2005,
> when I run the page and insert a record pulse, whenever I get the
> following error:
>
> How could fix it?
>
>
> [OleDbException (0x80004005): Ha intentado asignar el valor Null a una
> variable que no es un tipo de datos Variant.]
>
> System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult
> hr) +65
>
> System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS
> dbParams, Object& executeResult) +181
> System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
> +307
> System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior,
> Object& executeResult) +77
> System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior
> behavior, String method) +188
> System.Data.OleDb.OleDbCommand.ExecuteNonQuery() +113
> System.Web.UI.WebControls.SqlDataSourceView.ExecuteDbCommand(DbCommand
> command, DataSourceOperation operation) +495
> System.Web.UI.WebControls.SqlDataSourceView.ExecuteInsert(IDictionary
> values) +557
> System.Web.UI.DataSourceView.Insert(IDictionary values,
> DataSourceViewOperationCallback callback) +173
> System.Web.UI.WebControls.FormView.HandleInsert(String commandArg,
> Boolean causesValidation) +627
> System.Web.UI.WebControls.FormView.HandleEvent(EventArgs e, Boolean
> causesValidation, String validationGroup) +745
> System.Web.UI.WebControls.FormView.OnBubbleEvent(Object source,
> EventArgs
> e) +163
> System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
> +56
> System.Web.UI.WebControls.FormViewRow.OnBubbleEvent(Object source,
> EventArgs e) +118
> System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
> +56
> System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +107
> System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String
> eventArgument) +178
>
> System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String
> eventArgument) +31
> System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
> sourceControl, String eventArgument) +32
> System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +244
> System.Web.UI.Page.ProcessRequestMain(Boolean
> includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3837
>
>
 | 
Pages: 1
Prev: Modify appSettings in wen.config file.
Next: AJAX calendar control