SqlHelper problem

[Mike Fors]

Why does the following code error out when there is a null
in the field I'm trying to retrieve? As it stands I need
to check each field for nulls. Anybody know of an easier
way?

SqlDataReader MyDR = SqlHelper.ExecuteReader
(SessionInfo.ConnString, "sp_SctyDetail", sctyid);

SctyDetail MySctyDetail = new SctyDetail();

MySctyDetail.sctypersid = MyDR.GetInt32(1);

Mike