Getting Error when Updating AccessDataSource via Gridview in asp.net
Posted on 2010-11-07
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??