title: how to fetch next record from ms access table in vb .net
body: <p>i am working with a MCQ app in vb .net i want to fetch every record frrom MS ACCESS database table called Q_A....here is my code</p>
  
  <pre><code>Dim i As Integer = 0
      con = New OleDb.OleDbConnection
      con.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=MCQ.accdb"
      Try
          Dim da As New OleDb.OleDbDataAdapter("SELECT * FROM Q_A ", con)
          If ds.Tables("Q_A").Rows.Count &gt; 0 Then
  
  
              da.Fill(ds, "Q_A")
              lblQno.Text = ds.Tables("Q_A").Rows(i).Item(0).ToString()
              lblQuestion.Text = ds.Tables("Q_A").Rows(i).Item(1).ToString()
              rbtn1.Text = ds.Tables("Q_A").Rows(i).Item(2).ToString()
              rbtn2.Text = ds.Tables("Q_A").Rows(i).Item(3).ToString()
              rbtn3.Text = ds.Tables("Q_A").Rows(i).Item(4).ToString()
              rbtn4.Text = ds.Tables("Q_A").Rows(i).Item(5).ToString()
  
              i = i + 1
  
  
          End If
  
          con.Close()
  
      Catch ex As Exception
          MsgBox(ex.Message.ToString)
      End Try
  </code></pre>
  
  <p>but i am not able to fetch next row using this code..pls help me..thanks in advance</p>