How to retrieve records from the database one at a time?

•

What is DaniWeb IT Discussion Community?

You're currently browsing the ASP.NET section within the Web Development category of DaniWeb, a massive community of 374,171 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,446 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our ASP.NET advertiser: Lunarpages ASP Web Hosting

Thread Tools Display Modes

Views: 447 | Replies: 2

•

Join Date: Mar 2008

Posts: 1

Reputation: cynxiann is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

cynxiann

Offline

Newbie Poster

How to retrieve records from the database one at a time?

Mar 24th, 2008

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..

eg.
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. (:

•

Join Date: May 2005

Posts: 494

Reputation: techniner is an unknown quantity at this point

Rep Power: 4

Solved Threads: 18

techniner

Offline

Posting Pro in Training

Re: How to retrieve records from the database one at a time?

Mar 25th, 2008

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

Did my post help?
Visit Little Jon's Web Portal

Generate Traffic with Maximum Traffic Software

•

Join Date: Sep 2007

Posts: 1,054

Reputation: SheSaidImaPregy is an unknown quantity at this point

Rep Power: 3

Solved Threads: 61

SheSaidImaPregy SheSaidImaPregy is offline

Offline

Veteran Poster

Re: How to retrieve records from the database one at a time?

Mar 28th, 2008

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.

 Help with Code Tags 
 VB.NET Syntax (Toggle Plain Text) 
Dim dtrReader As SqlDataReader = cmdSelect.ExecuteReader()
 
If dtrReader.HasRows Then
  repeater1.DataSource = dtrReader
  repeater1.DataBind()
End If
 
 
 
------------
 
<asp:Repeater ID="repeater1" runat="server">
<ItemTemplate>
  <asp:Label ID="lbl" Text='<%# Eval("fruitorColumnName") %>' runat="server" />
  <br />
</ItemTemplate>
</asp:Repeater>
Dim dtrReader As SqlDataReader = cmdSelect.ExecuteReader()

If dtrReader.HasRows Then
  repeater1.DataSource = dtrReader
  repeater1.DataBind()
End If



------------

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