MySQL - How in the world I check the NULL value of this guy?

I was trying to work on extracting information out from MySQL via ASP.NET. Since MySQL only provides the connector, and I can't really connect to MySQL from ASP.NET via simple configuration steps on the ASP.NET web form or web.config, I have to write my own class to do the job.

As it progressed, I found that MySQL behaves differently as compare to SQL Server in terms of handling NULL value. I could simply do a NULL checking on data return from SQL Server with the following syntax.

value = (data_table[column_name] == NULL ? NULL : data_table[column_name]);

So, since MySQL has provided us with a .NET connector, I would assume that the above would work as well; but sadly, it doesn't. Oh Dear, what has gone wrong with it? When I tried to debug the web form (yes, debugging a web form is possible in Visual Studio 2005), I found out that the NULL value is returned with '{}'. This is not NULL!!! So how should I do this? I was totally mad about this because if the syntax works for SQL Server, it should work for MySQL as well, so why in the world they don't make it that way?

Anyway, I know my complaint won't work so I tried to look from the Internet for any possible solution. I did a search on DBNull, since it was in the error message that being thrown out. I found out that DBNull can be used to determine the NULL value returned by MySQL, so I give it a try and it works. So instead of the usual syntax that I used, I have to replace the NULL like the following syntax.

value = (data_table["column_name"] = DBNull.Value ? NULL : data_table["column_name"]);

Problem solves, but yet it shows that it is very hard to work to integrate different tool together, and I'll be facing a lot of this situation again in the future, Oh Dear...

Comments

Post a Comment

Popular posts from this blog

Yahoo! Messenger voice call & video call disabled, why?

Was trying to help my colleague to troubleshoot her laptop, where the Yahoo! Messenger voice chat & video chat are disabled even though the setup of the sound & video are all correctly configured.  Yet, it will still throw the error message "Your computer is not connected to the network", which is quite amazingly considered that the wireless network is working plus the Skype is able to make the call. After several finding on the Internet and on some help site, non of the solutions are able to solve the problem.  Then I recalled the other colleague is also using the same laptop and her Yahoo! Messenger is able to use video call & voice call.  I was guessing the whole time of what could be the possible cause that hers is working but not this one.  Then a thought came to my mind, could it be the firewall? The firewall is correctly configured, so what else inside there that is blocking the connection?  The other security software that's installed is the Trend
Read more

Sport's Injuries - Treatment for bruises

I have a knock on both my legs last Sunday during a Futsal session. I have a knock on my lower right shin, while sprain my left ankle. It is not a pleasant experience at all to have both legs injured. It is very painful and totally immobilized me. What's important right now is to get it treated. I have tried to elevate both my legs in order to not let the blood concentrated at the injured spot, plus put ice at the injured area. I have even consulted with a doctor regarding the injuries, and am thankful that there's nothing wrong with my right shin. Still, it's not healing that well because the swelling has not resided. Since I'm living alone, it will be hard for it to heal because I need to be mobilize all the time. With the help of the Internet, I'm trying to surf for information that could help to provide first-aid treatment. The following are my finding from the Internet and from family tradition treatment: Elevate the injured leg. Apply ice for about 30
Read more

Web Development: Disable, Validate, & Enable Buttons

I bounced into this problem during a Web UI development, of which I'd say it's quite a common issue. Whenever a button is clicked, ideally it would be good to disable it to avoid continuous clicking. Of course, it may not be the case in certain circumstances, i.e. loading of images, of which sometimes clicking the button again would surely making it load faster. However, in the latest development that I involved in, I need to make sure that the button as to be disabled to avoid continuous clicking that would cause some Javascript error that would cause the whole website to stop working. I've no idea why this is happening, and my only explanation should be because the execution time is short & it's AJAX, therefore the continuous clicking would cause some process not able to be executed timely and causing this issue. So after some research on the Internet, I found that in order to disable the button during a button click event that has a postback, the onclick event
Read more