trims30
asked on
Getting Error when Updating AccessDataSource via Gridview in asp.net
I am working in ASP.Net - Visual Studio 2008 - VB Code
Have a Gridview bound to an AccessDataSource and have configured it to allow Updating
It works correctly and updates columns as long as all grid columns (except Primary Key) are set to ReadOnly=False
Setting one or more columns to ReadOnly=True gives me the error:
You tried to assign the Null value to a variable that is not a Variant data type
My guess is that the ReadOnly fields are trying to put Null values into database fields on update.
How do I get around this problem??
Lee
Have a Gridview bound to an AccessDataSource and have configured it to allow Updating
It works correctly and updates columns as long as all grid columns (except Primary Key) are set to ReadOnly=False
Setting one or more columns to ReadOnly=True gives me the error:
You tried to assign the Null value to a variable that is not a Variant data type
My guess is that the ReadOnly fields are trying to put Null values into database fields on update.
How do I get around this problem??
Lee
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
OOPS - after looking at my code found I was using e.NewValues("LastMeter") rather than e.OldValues("LastMeter") All is working now.
Thank you
Thank you
ASP.NET
The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications
128K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER
In the RowUpdating Event I'm doing a calculation referencing one of the readonly columns and am getting Zero for the readonly item.
In code below, "LastMeter" is ReadOnly and "MeterInput" and "UsageInput" are editable.
How do I get value of "LastMeter" during Update if it's ReadOnly??
Lee
Private Sub GridView1_RowUpdating(ByVa
If e.NewValues("MeterInput") > e.NewValues("LastMeter") Then
e.NewValues("UsageInput") = e.NewValues("MeterInput") - e.NewValues("LastMeter")
End If
End Sub
End Class