ISNULL FUNCTION

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Ezzeddin
    #1

    ISNULL FUNCTION

    How can I use ISNULL() function in asp.net

    Thanks

    Tags: None
    • William Ryan
      #2
      Re: ISNULL FUNCTION

      string s = "SELECT ISNULL(myField, ValueIfItsNull) From MyTable";

      myCommand.Comma ndText = s;
      ....then execute your query here.

      "Ezzeddin" <ezoarabi@hotma il.com> wrote in message
      news:08af01c36f 15$57ff95b0$a60 1280a@phx.gbl.. .[color=blue]
      > How can I use ISNULL() function in asp.net
      >
      > Thanks
      >[/color]


        Comment

        • Scott M.
          #3
          Re: ISNULL FUNCTION

          IsNull has been replaced with IsDBNull()

          If IsDBNull(x) then exit sub


          "Ezzeddin" <ezoarabi@hotma il.com> wrote in message
          news:08af01c36f 15$57ff95b0$a60 1280a@phx.gbl.. .[color=blue]
          > How can I use ISNULL() function in asp.net
          >
          > Thanks
          >[/color]


            Comment

            Previous template Next
            Working...