title: How to select n rows using IDataReader
body: <p>[ASP .Net - Microsoft Visual Web Developer 2010]</p>
  
  <p>Hi all,</p>
  
  <p>I've problem with this code:</p>
  
  <pre><code>With MenuNavCatDataSource
    Dim xReader As Data.IDataReader = .Select(DataSourceSelectArguments.Empty)
  
    If xReader.Read Then
      MenuNavCat1.Text = xReader.Item("MenuCategoryName")
      MenuNavCat2.Text = xReader.Item("MenuCategoryName")
      MenuNavCat3.Text = xReader.Item("MenuCategoryName")
      MenuNavCat4.Text = xReader.Item("MenuCategoryName")
      MenuNavCat5.Text = xReader.Item("MenuCategoryName")
    End If
  End With
  </code></pre>
  
  <p>I've 5 label and I want to parse the content of the label from the database. The database contains menus ordered from 1 to 5. And I want to show it on:
  - 'MenuNavCat1' label, menu with order number 1 on database, 
  - 'MenuNavCat2' label, menu with order number 2 on database, and so on...</p>
  
  <p>How to add where statement to the code, just like 'WHERE OrderNo = 1', and so on..?</p>
  
  <p>Need your help guys..</p>
  
  <p>Thank you so much.</p>
  
  <hr>
  
  <p><strong>EDIT</strong></p>
  
  <p>Here is the database:</p>
  
  <p><strong>Table MenuNavCategory</strong></p>
  
  <pre><code> | Column Name  |  Data Type   | 
   |-----------------------------| 
   | MenuNavCatID |  int         | 
   | CategoryName |  varchar(20) |  
   | OrderNumber  |  int         |
   |-----------------------------|
  </code></pre>
  
  <p>And there is some value inserted to the table.
  I want to show the 'CategoryName' onto some label.
  For example:</p>
  
  <p>lblCat1  |  lblCat2  | lblCat3  | lblCat4</p>
  
  <p>Then, using that xReader.Read, store the value on the database onto that label based on the OrderNumber...</p>