How to pass a null variable to a SQL Stored Procedure from C#.net code

by 
SqlParameters[1] = new SqlParameter("Date1", SqlDbType.SqlDateTime);
SqlParameters[1].Value = DBNull.Value;
SqlParameters[1].Direction = ParameterDirection.Input;

…then copy for the second.

More Related Contents:

  1. What are the pros and cons to keeping SQL in Stored Procs versus Code [closed]
  2. Passing List to SQL Stored Procedure
  3. What is passing parameters to SQL and why do I need it?
  4. Add WHERE clauses to SQL dynamically / programmatically
  5. Delete from two tables? [closed]
  6. Procedure or function xxxxx has too many arguments specified [duplicate]
  7. An unhandled exception of type ‘System.InvalidOperationException’ occurred in System.Data.dll?
  8. How to pass an array into a SQL Server stored procedure
  9. How to execute a stored procedure within C# program
  10. Calling stored procedure with return value
  11. Using stored procedure output parameters in C#
  12. Insert entire DataTable into database at once instead of row by row?
  13. Getting return value from stored procedure in C#
  14. SQL error: Incorrect syntax near the keyword ‘User’
  15. Query extremely slow in code but fast in SSMS
  16. How to retrieve data from a SQL Server database in C#?
  17. Using DateTime in a SqlParameter for Stored Procedure, format error
  18. Code to validate SQL Scripts
  19. Any way to SQLBulkCopy “insert or update if exists”?
  20. Entity Framework – stored procedure return value
  21. SQLException : String or binary data would be truncated
  22. Multi threading C# application with SQL Server database calls
  23. What’s the fastest way to bulk insert a lot of data in SQL Server (C# client)
  24. ALTER TABLE DROP COLUMN failed because one or more objects access this column
  25. How to pass XML from C# to a stored procedure in SQL Server 2008?
  26. Can I use ADFS 2.0 to authenticate certain users against SQL Server?
  27. ExecuteNonQuery returning -1 when using sql COUNT despite the query string
  28. How to insert data into SQL Server
  29. Database Error: There is no row at position 0
  30. Capturing count from an SQL query

Leave a Comment