[ajaxpro] Re: dealing with null database values

Fri, 03 Nov 2006 23:17:10 -0800

if you use datasets you can also to it at the level, thus you don't need to mess about with the database scheme

On 11/4/06, o0JoeCool0o <[EMAIL PROTECTED]> wrote:

Just figured this out and thought i would post to make someone elses
life easier.

I was struggling with null values from databases of course when you
assign the field to a textbox if the value is null you actually get the
text "null" in the textbox.

Once I asked for a solution and was told to put an if statement in for
each text field...

well that was too much work for me I figured out if you are using SQL
Or pretty muc hany database out there, you can set on the database side
a default value for each field. set it to '' (two single quotes) and
from then on every field on a new record will equal an empty string
instead of null

yay! no more null in the textboxes.



--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ajax.NET Professional" group.

To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]

For more options, visit this group at http://groups.google.com/group/ajaxpro

The latest downloads of Ajax.NET Professional can be found at http://www.ajaxpro.info/

Don't forget to read my blog at http://weblogs.asp.net/mschwarz/

The open source project is now located at
http://www.codeplex.com/Wiki/View.aspx?ProjectName=AjaxPro
-~----------~----~----~----~------~----~------~--~---

Reply via email to