Q:

Data is Null error in GetDateTime()

Still.I get an error on this part.(another part of my codes where I really want to do is to put IsDBNull on it)
But the I know it'll not work in GetDateTime. Is there any possible solution?
data[key].ApproverList.Add(
    new Approver() {
                        RequestID = key,
                        FullName = reader.IsDBNull(27) ? null : reader.GetString(27),
                        ApproveDate = reader.GetDateTime(28)
                   });

same as the 
FullName with reader.IsDBNull(27) ? null : reader.GetString(27)
how about 
ApproveDate = reader.GetDateTime(28)

What will be in here?

A:

Try this 
DateTime? startingDate;

if !reader.IsDBNull(reader.GetOrdinal("STARTINGDATE"))
{
    startingDate = reader.GetDateTime(reader.GetOrdinal("STARTINGDATE"));
}
else
{
    startingDate = null;
}

I know you are leaving .. 

