title: How do i display data that exceeds a given value?
body: <p>I have a table with a price and in there has all the prices "Customers" paid so </p>
  
  <pre><code>| ID | Price |
  |----|-------|
  |  1 |  5.00 |
  | 50 |  6.70 |
  </code></pre>
  
  <p>I want to make something so when you enter 3 or 3.00 in a textbox then it will show all the records that exceeds that value so since <code>ID</code> 1 paid 5 quid then they will show and same with <code>ID</code> 50. I want them to display in my datagridview.</p>
  
  <p>What i have so far is:</p>
  
  <pre><code>myDA = New OleDbDataAdapter
      myDataSet = New DataSet
      myDA.SelectCommand = New OleDbCommand()
  
      Try
          cmd = New OleDbCommand()
          cmd.CommandText = "Select sum(Paid) as total from tblorder"
          cmd.Connection = con
          If con.State = ConnectionState.Closed Then con.Open()
          myDA.SelectCommand = cmd
          myDA.Fill(myDataSet, "TTotal")
          TextBox1.Text = CStr(myDataSet.Tables("TTotal").Rows(0).Item(0))
          DataGridView1.DataSource = myDataSet.Tables("TTotal").DefaultView
          con.Close()
  
      Catch ex As Exception
          MessageBox.Show(ex.Message)
      End Try
  </code></pre>