title: incorrect integer value: "for column 'student_no' at row 1
body: <p>i'm having a problem i insert a value it will show a error:<br>
  incorrect integer value: "for column 'student_no' at row 1  </p>
  
  <p>this is the code</p>
  
  <pre><code>    Try
  
              MySqlConnection.Open()
              Dim query As String
              query = " insert into mcs.payment(student_no, mode, registration_fee, miscellaneous_fee, tuition_fee, ptca_fee, computer_fee, user) values ('" &amp; lblstudentno.Text &amp; "', '" &amp; ComboBox1.Text &amp; "','" &amp; txtregfee.Text &amp; "', '" &amp; txtmisfee.Text &amp; "', '" &amp; txttuitionfee.Text &amp; "', '" &amp; txtptcafee.Text &amp; "', '" &amp; txtcompfee.Text &amp; "', '" &amp; lbluser.Text &amp; "') "
              Dim Command As New MySqlCommand(query, MySqlConnection)
              READER = Command.ExecuteReader
  
              MessageBox.Show("OK")
          Catch ex As Exception
              MessageBox.Show(ex.Message)
          Finally
              MySqlConnection.Dispose()
  
          End Try
  </code></pre>
  
  <p>can you help me???</p>