SqlDataReader dbnull values

Question

I have a question about SqlDataReader:

Is there some way to modificated the values in SqlDataReader? For example:

while (sdr.Read())
{
     double PRICE = double.Parse(sdr["PRICE"].ToString());
     if (PRICE == null) PRICE = Single.MinValue;
     .....
}

I would like that for each null value in my DataReader, assigned Single.MinValue to use after this modifications in another process

score 0 · Accepted Answer · answered Jul 02 '12 at 10:39

The DataReader has a defined set of operations that revolve around its connected, forward-only, read-only nature.

You may use DataSet to achieve what you want.

1 Answers1