I'm assigning values to an ADO recordset in C#. Some of the numerical fields (integer) are assigned the value of "null"; however, when I check the value of the recordset field when it is passed to another method it is now '0'. If I don't do the assignment, the recordset field stays null. Is this typical behavior for C# that if a null value assignment is made to a numerical type -- the value is initialized to 0? String fields stay null when the null assignment is made.

Greg

In a database an integer column can be null. In .NET integers are native value types and can not be null. You should not be able to assign null to a integer variable. A new integer defaults to 0 (i'm pretty sure). If you want to assign null to a value to be saved to the database, try assigning DBNull.

-Peter