<< Extender control ValidatorCalloutExtender cannot extend TextBox | ASP.NET redirect a web page with AJAX loading indicator image >>

Data is Null This method or property cannot be called on Null values

by bryian 9. January 2010 09:14

I was working on one of the VB.NET application that have been developed several years ago and I saw some declaration like Str7 = objDr.GetString(7).ToString, Str8 = objDr.GetString(8).ToString, Str9 = objDr.GetString(9).ToString and so on. It puzzled me, what will happen if the value in the column 7, 8, or 9 is null. Then, I went in to the SQL database, pull out the table and changed the value to null. And I received this error "

Data is Null. This method or property cannot be called on Null values.

" If you happen to come across this situation, below is the work around.

Solution:

If (Not objDr(8) Is DBNull.Value) Then
     Str8 = Trim(objDr.GetString(8).ToString)
End If

e3e34614-19dd-468a-935b-37b1210121e6|2|1.0

Tags: data is null. this method or property cannot be called on null values, checking for a null value in a data reader

Error

ASP-NET AJAX MultiHandleSliderExtender - Slide by Year and MonthTutorial - How to utilize ASP.NET MultiHandleSlider extender to select year and month in a range, an...Microsoft JScript runtime error: null is null or not an objectMicrosoft JScript runtime error 'null' is null or not an objectSQL Injection and Cross-Site ScriptingAn article on SQL Injection and Cross-Site Scripting with sample code

Comments

1/13/2010 2:12:09 PM #

Wow database? good articles

Bisnis Internet

1/20/2010 2:08:58 PM #

Fantastic database..and informative blog post..keep up the great work and keep updated your site...

psychics uk

1/29/2010 5:47:00 PM #

Good call. Nice work and share.

Joseph Mckoon

2/12/2010 9:58:42 PM #

Very nice information.

Seattle SEO

2/14/2010 8:18:02 AM #

While reading your blog it seems that you research on this topic very much. I must tell you that your blog is very informative and it helps other also.

Homework Help Math

3/1/2010 10:57:20 AM #

This article was extremely interesting, especially since I was searching for thoughts on this subject last week.

Assignment Help

3/2/2010 12:13:09 PM #

Thanks for the post. I agree with the information you have provided here.

Kegel exercises for men

3/8/2010 8:09:56 PM #

Well said, I could not agree more with you on this issue. I think your blog is very popular on this topic judging by all the other comments posted to it. I just wanted to leave a comment to appreciate your hard work that must have gone into this blog.
Thanks for posting and sharing with all – Cheers - Jesse

Jelqing techniques

3/18/2010 8:41:24 PM #