I have the following code
foreach (DataRowView dr in Data)
{
if (dr == System.DBNull.Value)
{
nedID = 1;
}
}
but i get the following error
Operator ==
cannot be applied to operands of type System.Data.DataRowView
and System.DBNull
please can some one advice me on how i can check if the value is null or DBNULL
You need to specify the field name or index.
foreach (DataRowView dr in Data)
{
if (dr["nameOfField"] == System.DBNull.Value)
{
nedID = 1;
}
}
You need to replace dr == System.DBNull.Value
with...
Convert.IsDBNull(dr["somefield"])
which returns true if it's DBNnull
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With