How pass null to stored proc

Discussion in 'ASP .Net' started by Cirene, May 26, 2008.

  1. Cirene

    Cirene Guest

    How do I pass a null to a stored proc? This doesn't seem to work....

    MyCommand.Parameters.AddWithValue("@RecurranceStorage", System.DBNull)
    Cirene, May 26, 2008
    #1
    1. Advertising

  2. System.DBNull.Value

    Hope this helps,
    Mark Fitzpatrick
    Microsoft MVP - Expression

    "Cirene" <> wrote in message
    news:...
    > How do I pass a null to a stored proc? This doesn't seem to work....
    >
    > MyCommand.Parameters.AddWithValue("@RecurranceStorage", System.DBNull)
    >
    >
    Mark Fitzpatrick, May 26, 2008
    #2
    1. Advertising

  3. Cirene

    Cirene Guest

    Thanks Mark... as usual
    "Mark Fitzpatrick" <> wrote in message
    news:%...
    > System.DBNull.Value
    >
    > Hope this helps,
    > Mark Fitzpatrick
    > Microsoft MVP - Expression
    >
    > "Cirene" <> wrote in message
    > news:...
    >> How do I pass a null to a stored proc? This doesn't seem to work....
    >>
    >> MyCommand.Parameters.AddWithValue("@RecurranceStorage", System.DBNull)
    >>
    >>
    Cirene, May 27, 2008
    #3
  4. You're very welcome!

    Mark

    "Cirene" <> wrote in message
    news:OTbM#...
    > Thanks Mark... as usual
    > "Mark Fitzpatrick" <> wrote in message
    > news:%...
    >> System.DBNull.Value
    >>
    >> Hope this helps,
    >> Mark Fitzpatrick
    >> Microsoft MVP - Expression
    >>
    >> "Cirene" <> wrote in message
    >> news:...
    >>> How do I pass a null to a stored proc? This doesn't seem to work....
    >>>
    >>> MyCommand.Parameters.AddWithValue("@RecurranceStorage", System.DBNull)
    >>>
    >>>

    >
    >
    Mark Fitzpatrick, May 27, 2008
    #4
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. David Lozzi
    Replies:
    3
    Views:
    1,929
    David Lozzi
    Jun 1, 2005
  2. JG
    Replies:
    0
    Views:
    295
  3. Gabriel Genellina
    Replies:
    0
    Views:
    411
    Gabriel Genellina
    Nov 25, 2006
  4. bogdan
    Replies:
    3
    Views:
    554
    bruce barker
    Apr 8, 2008
  5. Jason  Vogel
    Replies:
    0
    Views:
    93
    Jason Vogel
    Nov 28, 2006
Loading...

Share This Page