How pass null to stored proc

  • Thread starter Thread starter Cirene
  • Start date Start date
C

Cirene

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

MyCommand.Parameters.AddWithValue("@RecurranceStorage", System.DBNull)
 
System.DBNull.Value

Hope this helps,
Mark Fitzpatrick
Microsoft MVP - Expression
 

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do you prefer to access/query data? 2
SP Expects paramater not supplied error 7
sqlDataSource UpdateQuery withe stored procedure and parameters? 4
Gridview not getting sp records 2
Passing null to date/time field 3
How to get a dynamic temp table into a 2003 .NET dataset 1
Parameter Type/Size Property Values for VARCHAR(MAX) Stored Proc Parameter 2
Visual studio 2005 corrupt MS SQL 2000 stored procedures 2

Back
Top