<div>
<div class="content wysiwyg-content">
Friends, 
 
I have a problem. My stored procedure produces an integer values which I am assigning to an Nullable integer variable. 
 
Dataclass where I call my Stored proc 
------------ 
//Typecasting error happens here . Unable to cast from object to integer datatype 
userProfile.NS_ID = Convert.ToInt32(dr.ItemArray[41]); 
 
userprofile class 
------------ 
 
public int? NMLS_ID 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; { 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; get; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; set; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } 
 
NS_ID is should get an integer..based on which I do my own business logic. but it is expected that 99% of time ..my stored proc would be producing a null because my db is fresh and users have not started using it. 
 
How do i handle this. 
 
REgards 
Subbu
</div>
</div>

Friends,

I have a problem. My stored procedure produces an integer values which I am assigning to an Nullable integer variable. 

Dataclass where I call my Stored proc
------------
//Typecasting error happens here . Unable to cast from object to integer datatype
userProfile.NS_ID = Convert.ToInt32(dr.ItemArray[41]);

userprofile class
------------

public int? NMLS_ID
            {
                  get;
                  set;
            }

NS_ID is should get an integer..based on which I do my own business logic. but it is expected that 99% of time ..my stored proc would be producing a null because my db is fresh and users have not started using it.

How do i handle this.

REgards
Subbu

Null handling in C#

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).