title: error when inserting C#'s decimal into SQL numeric
body: <p>i'm using SQL server 2008 and have a table with a field type of numeric(7,3), into which i want to insert values using a C# web-service (i know that values won't be more than 4 digits before the decimal and 3 digits afterwards).  therefore my C# variable is of type decimal (as i read <a href="https://stackoverflow.com/questions/425389/c-sharp-equivalent-of-sql-server-2005-datatypes">here</a>).
  it basically looks like this - </p>
  
  <pre><code>SqlParameter vsp = new SqlParameter("@VideoStartPoint", SqlDbType.Decimal);
                      vsp.Scale = 3;
                      vsp.Precision = 7;
                      vsp.Value = VideoStartPoint;
  </code></pre>
  
  <p>however, i found out that it works <strong>only</strong> if the value is less than 10.  for any value from 10 and above i get an error - "<em>Error converting data type numeric to numeric</em>".
  i know there's no problem in my table, for when i insert it using SQL i have no problem with >10 values.</p>
  
  <p>any ideas?
  cheers,
  eRez</p>