title: Is it possible to take the last 5 records of my dataset appear in the datagridview?
body: <p>i have a access database and i created a connection between vb and access and filled the dataset, how can i only show the last 5 records of my dataset, this is my code:</p>
  
  <pre><code>Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
      Dim sql As String = "SELECT * from Student"
      Dim imagepath As String
  
      dbprovider = "PROVIDER=Microsoft.ACE.OLEDB.12.0;"
      dbsource = "Data Source = C:\Users\toshiba\Documents\school.accdb"
      con.ConnectionString = dbprovider &amp; dbsource
      con.Open()
      da = New OleDb.OleDbDataAdapter(sql, con)
      da.Fill(ds, "db1")
  
      con.Close()
      t = ds.Tables("db1") 'rah esta3mela tahet'
      DataGridView1.DataSource = t
  </code></pre>
  
  <p>this lets all the data appear but i only want the last 5 records to appear any help please?</p>