I am new to vb.net and trying to display the records in a sequential manner from sqlserver, but only the last record is displayed. in vb we were using rs.movenext and its not there in this. how to go about ????

While dr.Read
            TextBox1.Text = dr(0).ToString()
            TextBox2.Text = dr(1).ToString()
End While

Hi there,

In ADO.NET, the Read method takes care of EOF and MoveNext at the same time. So, your code probably works as expected when it comes to the database. However, look at this:

  TextBox1.Text = dr(0).ToString()

You're overwriting the Text on each iteration. Try this instead:

  TextBox1.Text += dr(0).ToString()

This adds the data for each record to the current Text.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

Hi Imar,

Now my records concatenated in the textboxes. i have 4 records in my database, except the first record all the other records are displayed together!!!!!!!!:(
suppose my records like this
       name rollno
         a 10
         b 20
         c 30
         d 40

now after using as what you told

While dr.Read()

            TextBox1.Text += dr(0).ToString()

            TextBox2.Text += dr(1).ToString()
End While

it is like

textbox1 bcd
textbox2 10203040

I want to display one record at a time......how is it possible???

What do you mean with "one record at a time"? By a user's click? Or in separate lines / controls?

In what environment is this? Windows Forms / Web Forms?

Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

It is Windows Form. I want to display similar results that we display using rs.Movenext in vb, one record at a time!!!!!!i.e

i have a command button "next" when i click that only the first record

textbox1 = a
textbox2 = 10

when i click the next button again it should disply the next set of records etc......

MoveNext doesn't do anything UI related; all it does is move the Recordset to the next record. You'll need to bind your data to a UI control somehow to display it on screen.

Search Google for

"windows forms" database databind

to get some starter articles.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

Hi ,

Thanks a lot Imar :)!!!!!!! its now working.I was not aware of databinding concept and now wow its interesting to know new concepts!!!!!!!