title: Error converting data type int to tinyint
body: <p>I am new to  stored procedures. When i run this i get an error saying Error converting data type int to tinyint. In my C# was the following code:</p>
  <pre><code>mySqlcmd.CommandText = &quot;EXECUTE PhoneNumber_Insert  @p_PhoneNumberTypeID, @p_PersonID&quot;;
  mySqlcmd.Parameters.Add(&quot;@p_PhoneNumberTypeID&quot;, SqlDbType.TinyInt).Value = 1;
  mySqlcmd.Parameters.Add(&quot;@p_PersonID&quot;, SqlDbType.Int).Value = &quot;754381&quot;;
  mysqlConnection.Open();
  mySqlcmd.ExecuteNonQuery();
  mysqlConnection.Close();
  </code></pre>