Bonnie,

I'm curious about what you think of Michel's solution.

K



\>Kevin,
>
>I'm sure I've posted my GetNonNull set of static methods here a gazillion times. <g> Here it is again in the form of a link to my blog post about it:
>
>http://geek-goddess-bonnie.blogspot.com/2009/11/getting-non-null-data.html
>
>~~Bonnie
>
>
>
>
>>I'm reading the values off a dataset onto class properties:
>>
>>

>>public override void LoadData()
>>{
>>    DataSet ds = AppDataAccess.GetProjects(this.RecordId);
>>
>>    if (ds != null && ds.Tables.Count > 0)
>>    {
>>        _ProjectKey = (int)ds.Tables[0].Rows[0]["ProjectKey"];
>>        _ClientKey = (int)ds.Tables[0].Rows[0]["ClientKey"];
>>        _ProjectTypeKey = (int)ds.Tables[0].Rows[0]["ProjectTypeKey"];
>>        _RateTypeKey = (int)ds.Tables[0].Rows[0]["RateTypeKey"];
>>        _ProjectStatusKey = (int)ds.Tables[0].Rows[0]["ProjectStatusKey"];
>>        _PriorityKey = (int)ds.Tables[0].Rows[0]["PriorityKey"];
>>
>>        if (ds.Tables[0].Rows[0]["ManagerKey"] != DBNull.Value)
>>        {
>>            _ManagerKey = (int)ds.Tables[0].Rows[0]["ManagerKey"];
>>        }
>>
>>        _ProjectName = ds.Tables[0].Rows[0]["ProjectName"].ToString();
>>        _ProjectCode = ds.Tables[0].Rows[0]["ProjectCode"].ToString();
>>        _RateAmt = (float)ds.Tables[0].Rows[0]["RateAmt"];
>>        _EstHours = (float)ds.Tables[0].Rows[0]["EstHours"];
>>        _TotalHours = (float)ds.Tables[0].Rows[0]["TotalHours"];
>>        _EstStartDate = (DateTime)ds.Tables[0].Rows[0]["EstStartDate"];
>>        _EstEndDate = (DateTime)ds.Tables[0].Rows[0]["EstEndDate"];
>>        _ActualStartDate = (DateTime)ds.Tables[0].Rows[0]["ActualStartDate"];
>>        _ActualEndDate = (DateTime)ds.Tables[0].Rows[0]["ActualEndDate"];
>>        _PercentDone = (float)ds.Tables[0].Rows[0]["PercentDone"];
>>        _Comments = ds.Tables[0].Rows[0]["Comments"].ToString();
>>        _ProjectType = ds.Tables[0].Rows[0]["ProjectType"].ToString();
>>        _RateType = ds.Tables[0].Rows[0]["RateType"].ToString();
>>        _Status = ds.Tables[0].Rows[0]["Status"].ToString();
>>        _Priority = ds.Tables[0].Rows[0]["Priority"].ToString();
>>        _MgrFirstName = ds.Tables[0].Rows[0]["MgrFirstName"].ToString();
>>        _MgrLastName = ds.Tables[0].Rows[0]["MgrLastName"].ToString();
>>
>>    }
>>}
>>

>>
>>The problem is that I'm getting casting errors when there are DB nulls., Is there a better way of dealing with this other than the IF statement I used above? I don't want a bunch of IF's around each line above.
>>
>>Thanks