Visualize NULL values in data grids

Feb 1, 2012 at 10:15 AM

Hello, thank you for your great work!
I've noticed that in data grid it's currently not possible to see if a field is DB.NULL. Especially with string cols could be a problem because user doesn't know if a field is null or empty string.
It's possible to manage this case?
Thank you!

Coordinator
Feb 1, 2012 at 11:45 AM

You're welcome! I'm glad you like it!

I'll look into a solution for visualizing NULL database values. Perhaps showing NULL (in italics) like what the SQL Server Management Studio does. But then I'll also have to figure out what to do with empty strings, if I should also just set them to NULL or keep it as an empty string...

Anyway, thanks for the input! I'll look into this either tonight or over the next few nights :)

Feb 1, 2012 at 12:38 PM

I was developing a similar application as yours and I've used this solution:

I hope this may help you!

Coordinator
Feb 3, 2012 at 7:53 PM

I did committed some changes to the source code that displays NULL if the cell value is DBNull. I'll publish a new release soon

Feb 7, 2012 at 8:55 AM

Hi,

I've tried the new version, it works like a charm! Thank you very much!

Coordinator
Feb 7, 2012 at 9:08 AM

You're welcome, I'm glad you like it. Thanks for the suggestion!