Conversion from type 'DBNull' to type 'String' is not valid

[Chris]

Hi again,

I want to read all the records of a table with 2 fields.
The problem is that some records have null value in the second field.
This code below works when all records have both fields fiilled, but gives
the error:
"Conversion from type 'DBNull' to type 'String' is not valid" when not.

.....
comd = New System.Data.Ole Db.OleDbCommand ("select name,lok from pc",
oConnection)
dtreader = comd.ExecuteRea der
for i=0 to 41
dtreader.Read()
for j=0 to 1
f=dtreader.item (j)
Response.Write( f)
next
Response.Write( "<br>")
next
dtreader.Close( )

Thanks for hints.
Chris

[sloan]

You can either check for

IsDBNULL before setting it.

if ( !myDataReader.I sDBNull ( 0 ) )
{
string x = myDataReader.Ge tString(0);
}
Or you can find the SafeDataReader .. a class to help with this.
(google it, but its in vb.net)

"Chris" <cc*@sdsd.dc> wrote in message
news:uW******** ******@TK2MSFTN GP05.phx.gbl...

Hi again,

I want to read all the records of a table with 2 fields.
The problem is that some records have null value in the second field.
This code below works when all records have both fields fiilled, but gives
the error:
"Conversion from type 'DBNull' to type 'String' is not valid" when not.

....
comd = New System.Data.Ole Db.OleDbCommand ("select name,lok from pc",
oConnection)
dtreader = comd.ExecuteRea der
for i=0 to 41
dtreader.Read()
for j=0 to 1
f=dtreader.item (j)
Response.Write( f)
next
Response.Write( "<br>")
next
dtreader.Close( )

Thanks for hints.
Chris

[Chris]

Thanks

"sloan" <sl***@ipass.ne t> wrote in message
news:e4******** ******@TK2MSFTN GP04.phx.gbl...

You can either check for

IsDBNULL before setting it.

if ( !myDataReader.I sDBNull ( 0 ) )
{
string x = myDataReader.Ge tString(0);
}
Or you can find the SafeDataReader .. a class to help with this.
(google it, but its in vb.net)

"Chris" <cc*@sdsd.dc> wrote in message
news:uW******** ******@TK2MSFTN GP05.phx.gbl...

Hi again,

I want to read all the records of a table with 2 fields.
The problem is that some records have null value in the second field.
This code below works when all records have both fields fiilled, but gives the error:
"Conversion from type 'DBNull' to type 'String' is not valid" when not.

....
comd = New System.Data.Ole Db.OleDbCommand ("select name,lok from pc",
oConnection)
dtreader = comd.ExecuteRea der
for i=0 to 41
dtreader.Read()
for j=0 to 1
f=dtreader.item (j)
Response.Write( f)
next
Response.Write( "<br>")
next
dtreader.Close( )

Thanks for hints.
Chris