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