Using SqlDBType.Decimal in Prepared Statement C#
<p>am using a Prepared Statement in C#. </p>

<pre><code> SqlCommand inscommand = new SqlCommand(supInsert, connection);
 inscommand.Parameters.Add("@ordQty", SqlDbType.Decimal,18);
 inscommand.Prepare();
 u = inscommand.ExecuteNonQuery();
</code></pre>

<p>The above code throws below Exception:</p>

<p><em>SqlCommand.Prepare method requires parameters of type 'Decimal' have an explicitly set Precision and Scale.</em></p>

<p>EDIT:  How to avoid this Exception</p>
