title: How to pass a null variable to a SQL Stored Procedure from C#.net code
body: <p>Im calling a SQL stored procedure from a piece of C#.net code:</p>
  
  <pre><code>SqlHelper.ExecuteDataset(sqlConnection, CommandType.StoredProcedure, STORED_PROC_NAME, sqlParameters);
  </code></pre>
  
  <p>where the <code>sqlParameters</code> variable is defined as:</p>
  
  <pre><code>        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;
  </code></pre>
  
  <p>I need to now pass in another two parameters to this Stored Proc, (both are of type <code>SqlDateTime</code>), which are going to <em>NULL</em> in this case.</p>
  
  <p>Thanks,</p>
  
  <p>IN</p>