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

Question

Im calling a SQL stored procedure from a piece of C#.net code: ``` SqlHelper.ExecuteDataset(sqlConnection, CommandType.StoredProcedure, STORED_PROC_NAME, sqlParameters); ``` where the `sqlParameters` variable is defined as: ``` SqlParameter[] sqlParameters = new SqlParameter[SQL_NUMBER_PARAMETERS]; Log.Logger.Debug(string.Format("Running proc: {0} ", STORED_PROC_NAME)); SqlParameters[0] = new SqlParameter("fieldID", SqlDbType.BigInt ); SqlParameters[0].Value = fieldID; SqlParameters[0].Direction = ParameterDirection.Input; ``` I need to now pass in another two parameters to this Stored Proc, (both are of type `SqlDateTime`), which are going to NULL in this case. Thanks, IN

Accepted Answer

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

...then copy for the second.

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

Solution

Problem