Is there a way to error check the null value of fields returned in the results of an SQL query in ASp.NET. Reason this is important is that the Get methods of the data reader expect the fields to have non-null values.
For instance I need to add the null error checking for the following line of code:
gotName= sreader.GetString(sreader.GetOrdinal("Name")).ToString() <----------wont work if this field was null
Also, can someone suggest me a good book on ASP.NET programming that deals with issues like Datareader methods etc ,sorta like a bit more than a beginner but not quite an advanced reference I guess.