title: arithmetic overflow error for data type tinyint,value = 256
body: <p>byte number = 1;
  add(number);
  // form .cs </p>
  
  <pre><code>public static int Add( byte? order)
  {
    arParams[0] = new SqlParameter("@number", (number.HasValue) ? ((object)number) : DBNull.Value);
    // stored procedure call is made which takes paramaters, 
  }
  </code></pre>
  
  <p>Stored procedure looks like this</p>
  
  <pre><code>@number tinyint
  AS
  BEGIN
  IF @number IS NOT NULL
  BEGIN
    UPDATE 
      table1
    SET 
      number = number + 1
    WHERE 
      id=13
  END
  INSERT INTO 
   table1
  (
    number
  )
  VALUES 
  ( 
    number=@number
  )
  </code></pre>
  
  <p>///////why i am getting this error can any one illustrate please and how do i solve this</p>