I am getting the following error message:
"Data is Null. This method or property cannot be called on Null values."
The code causing this problem is something like this:
IDataReader dr = this.ExecReader(SelectCmd, out conn);
while (dr.Read())
{
MyString = dr.GetString(0);
}
This is processing a couple of thousand records and then errors with the message. How can I test for Null before calling GetString?
Thanks in advance for any help!
Kind Regards,
Mat