Post reply

retrive null value from a column

  • March 9, 2010 at 3:40 am

    #141880

    Hello ,

    I am facing a problem,i have entered null in a column having type datetime

    now when i retrive data in gridview it display empty cells for that column, and i want the value to be null.

    Is there a way to retrive null from the column and display it???

  • March 9, 2010 at 4:12 am

    #1130547

    It is correct that your grid shows nothing when a null value is entered - a null is an unknown value and can cause no end of fun if not handled correctly. It is not an empty field, or a zero value (to quote MS).

    If you do want something displaying when a null value is encountered then you can substitute the null value for something else. Have a look at IsNull in BOL (Books On-Line). If you're loading the grid via another method (using vb or suchlike) then there are commands within most languages to identify null values so you can take the appropriate action.

    Steve Hall
    Linkedin
    Blog Site

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply