title: Cannot convert data type nvarchar to numeric
body: <p>get this error to the <code>txtNum.Text</code> i dont know what to do i already tried the</p>
  
  <p><code>Convert.ToInt32</code> and <code>SqlDbType.Int</code> but it doesnt work please help me</p>
  
  <p>the total has a $ sign in it maybe that's the problem. the Total's DataType is Decimal</p>
  
  <pre><code>com = new SqlCommand(@"INSERT INTO Orders(
                          OrderDate, 
                          Username, 
                          FirstName, 
                          LastName, 
                          Address, 
                          Phone, 
                          Total, 
                          HasBeenShipped
                      ) 
                      VALUES(
                          GetDate(),
                          @p5, 
                          @p1, 
                          @p2, 
                          @p3, 
                          @p4, 
                          @p6,
                          'false'
                      )", con2);
  com.Parameters.AddWithValue("@p5", Label2.Text);
  com.Parameters.AddWithValue("@p1", txtFname.Text);
  com.Parameters.AddWithValue("@p2", TxtLname.Text);
  com.Parameters.AddWithValue("@p3", TxtAdd.Text);
  com.Parameters.AddWithValue("@p4", Convert.ToInt32(TxtNum.Text));
  com.Parameters.AddWithValue("@p6", lblTotal.Text);
  com.ExecuteNonQuery();
  </code></pre>