I have a stredproc which returns an email address if it finds in the tabel. I use this returned email and to insert records to another tabel and if it doesn't find a macthing record i want to be able to give a message to the user who is using the app that there is no macthing record foun . however when it doesn't find one it says.
System.NullReferenceException: Object reference not set to an instance of an object.
how can i handle that?