SqlDataReader and null fields

I am returning data using a SqlDataReader. Here is a snippet of code where
I am having a problem. What is the best way to handle nulls?

private void TGenerateJobSiteList2FromReader<T>(SqlDataReader returnData,
ref List<JobSite> jobSiteList)

{

while (returnData.Read())

{

JobSite jobSite = new
JobSite((string)returnData["JobName"], (int)returnData["JobSiteId"],
(string)returnData["Addr1"], (string)returnData["Addr2"],

(string)returnData["City"],
(string)returnData["state"]);

jobSiteList.Add(jobSite);

}

}

Morten
Sat Aug 04 04:06:53 CDT 2007

On Sat, 04 Aug 2007 05:20:05 +0200, Bill Gower <billgower@charter.net> w=
rote:

> I am returning data using a SqlDataReader. Here is a snippet of code =
where
> I am having a problem. What is the best way to handle nulls?
>
> private void TGenerateJobSiteList2FromReader<T>(SqlDataReader returnDa=
ta,
> ref List<JobSite> jobSiteList)
>
> {
>
> while (returnData.Read())
>
> {
>
> JobSite jobSite =3D new
> JobSite((string)returnData["JobName"], (int)returnData["JobSiteId"],
> (string)returnData["Addr1"], (string)returnData["Addr2"],
>
> (string)returnData["City"],
> (string)returnData["state"]);
>
> jobSiteList.Add(jobSite);
>
> }
>
> }
>
>
>

Hi Bill,

You need to test each field

if(returnData["JobName"] =3D=3D DBNull.Value)
{
// field is null
}

-- =

Happy coding!
Morten Wennevik [C# MVP]