move to next record in vb.net

[mariyana]

I have been trying to display the records from SQL server in a sequential manner using vb.net, but only the last record is displyed. how to display ????? in vb we were using rs.MoveNext and how to use in this.

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

do help me out soon!!!!!!!!!!!

[praveenkadiyalaengineer]

how to call connection string in .net which is saved in configeration file

[praveenkadiyalaengineer]

this is the correct method ,but u r not getting means please read all rows in table and make for loop

[moredotnet]

I have been trying to display the records from SQL server in a sequential manner using vb.net, but only the last record is displyed. how to display ????? in vb we were using rs.MoveNext and how to use in this.

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

do help me out soon!!!!!!!!!!!

Read this link http://moredotnet.goog lepages.com/ado.net2

[moredotnet]

http://moredotnet.goog lepages.com/ado.net2