I would like to know how can I retrieve results/records from a database one at a time to make it appear in different labels..

row number 1 of the database's records = apple
lb_fruit.Text = apple

row number 2 of the database's records = pear
lb_fruit2.Text = pear


And so on..
There's loads of rows that I need to retrieve..
Is there anyway then better then writing loads of sql statements?
Thanks loads in advance. (:

Yes, load them into an array and then for each on the array and display the entire array and build labels as needed.

I would stay away from the array, as there is no need to use more resources since you are already using a datareader to read the data into an array. Your best bet is to put a repeater (depending on your situation and where these labels are placed), and binding it to the repeater.

Dim dtrReader As SqlDataReader = cmdSelect.ExecuteReader()

If dtrReader.HasRows Then
  repeater1.DataSource = dtrReader
End If


<asp:Repeater ID="repeater1" runat="server">
  <asp:Label ID="lbl" Text='<%# Eval("fruitorColumnName") %>' runat="server" />
  <br />

This will spit out information in this manner: