<div>
Have you tried:<br />

<pre><code id="code-1025226">parameters[3] = new OdbcParameter(&quot;pOrigValue&quot;, (oldFieldsValues[ctrl.ID] == string.Empty) ? DBNull.Value.ToString() : oldFieldsValues[ctrl.ID]);
</code></pre>
</div>


<div>
try sending null instead of DBNull.Value - odbc should be smart enough to convert it for you.<br />

</div>


<div>
kaufmed,<br />
<br />
I tried it, and it stored an empty string instead of null .
</div>


<div>
packratt_jk,<br />
<br />
This also stores an empty string. 
</div>


<div>
<div class="content wysiwyg-content">
Dear experts,<br />
<br />
I want to execute a stored procedure, and some of the string parameters may be empty. Instead of passing to the stored procedure an empty string for saving in my database, I want to pass a DBNull.Value. I tried the following:<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; parameters[3] = new OdbcParameter(&quot;pOrigValue&quot;<wbr />, (oldFieldsValues[ctrl.ID] == string.Empty) ? DBNull.Value : oldFieldsValues[ctrl.ID]);<wbr /><br />
But I am getting an error:<br />
error CS0173: Type of conditional expression cannot be determined because there is no implicit conversion between 'System.DBNull' and 'string'<br />
Could you please tell me how I could do it correctly?<br />
Thanks.
</div>
</div>


Dear experts,

I want to execute a stored procedure, and some of the string parameters may be empty. Instead of passing to the stored procedure an empty string for saving in my database, I want to pass a DBNull.Value. I tried the following:
                    parameters[3] = new OdbcParameter("pOrigValue", (oldFieldsValues[ctrl.ID] == string.Empty) ? DBNull.Value : oldFieldsValues[ctrl.ID]);
But I am getting an error:
error CS0173: Type of conditional expression cannot be determined because there is no implicit conversion between 'System.DBNull' and 'string'
Could you please tell me how I could do it correctly?
Thanks.

try sending null instead of DBNull.Value - odbc should be smart enough to convert it for you.


kaufmed,

I tried it, and it stored an empty string instead of null .

packratt_jk,

This also stores an empty string. 

DBNull.Value for a string OdbcParameter

Dear experts,

I want to execute a stored procedure, and some of the string parameters may be empty. Instead of passing to the stored procedure an empty string for saving in my database, I want to pass a DBNull.Value. I tried the following:
                    parameters[3] = new OdbcParameter(&quot;pOrigValue&quot;, (oldFieldsValues[ctrl.ID] == string.Empty) ? DBNull.Value : oldFieldsValues[ctrl.ID]);
But I am getting an error:
error CS0173: Type of conditional expression cannot be determined because there is no implicit conversion between &#39;System.DBNull&#39; and &#39;string&#39;
Could you please tell me how I could do it correctly?
Thanks.

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).