Hi,
I have a table which has a column which can be the following values; NULL, 1, 2, 3.
I want to be able to return null to be bll layer. So in my BLL layer class I have a nullable(of integer) property to assign the column value of the table adapter.
When the select is carried out on the tableadapter, and then assigned to the property, there is an exception inside the generated accessor code. The code is trying to set the value of the column to an integer before it even gets to my BLL property of nullable type.
Now I can test for the property before I set it by doing
if not dr.IsMyCollumnNull
_MyColumn = dr.MyColumn
end if
But what I'm wondering is I have a property on the column AllowDBNull = TRUE in the table adapter. So is this not working then or is this for something else?
Seems a little confusing why you can't allow a t ...
Go to the complete details ...