vb.net database programming

[sandy]

hi friends...
i am new to VB.NET.i was trying to read some data from the database
using code,
and display that in 2 textboxes.i was able to get only the first row.
i used ExecuteReader() function of SqlCommand class and read()
function to read data..
i have put a button on the form to advance the records..
in that click method i have called the read() function...
but it's not moving to the next record...even after clicking the
button...
please help me anyone...
thanks and regards...
sandeep...

[rowe_newsgroups]

Re: vb.net database programming

Could you post your code? That way we can see what is going on.

Thanks,

Seth Rowe


sandy wrote:

hi friends...
i am new to VB.NET.i was trying to read some data from the database
using code,
and display that in 2 textboxes.i was able to get only the first row.
i used ExecuteReader() function of SqlCommand class and read()
function to read data..
i have put a button on the form to advance the records..
in that click method i have called the read() function...
but it's not moving to the next record...even after clicking the
button...
please help me anyone...
thanks and regards...
sandeep...

[sandy]

Re: vb.net database programming

Thanks Seth Rowe...

i will paste the code...


Protected Sub Page_Load(ByVal sender As Object, ByVal e As
System.EventArg s) Handles Me.Load

cn = New SqlConnection(" Data Source=VIDYAMAY I18\SQLEXPRESS; Initial
Catalog=model;I ntegrated Security=True")

sqlcmd = New SqlCommand()
sqlcmd.CommandT ext = "select * from infotab"
sqlcmd.Connecti on = cn
cn.Open()
sqlreader = sqlcmd.ExecuteR eader()

End Sub

Protected Sub Button1_Click(B yVal sender As Object, ByVal e As
System.EventArg s) Handles nextbutton.Clic k

sqlreader.Read( )
txtname.Text = sqlreader(0)
txtaddress.Text = sqlreader(1)

End Sub

Protected Sub Page_Unload(ByV al sender As Object, ByVal e As
System.EventArg s) Handles Me.Unload

cn.Close()

End Sub


i tried to fetch the records as i press the button and display the data
in textboxes...

thanks and regards
sandeep...

[Cor Ligthert [MVP]]

Re: vb.net database programming

Sandy,

Just use Databinding that makes it more easy and more from this time.

http://www.vb-tips.com/dbpages.aspx?ID=c4832a2a-2b95-4ded-93d9-4deb7fa4a0b8

I hope this helps,

Cor

"sandy" <sandy4grp@gmai l.comschreef in bericht
news:1160831843 .705145.254210@ k70g2000cwa.goo glegroups.com.. .

hi friends...
i am new to VB.NET.i was trying to read some data from the database
using code,
and display that in 2 textboxes.i was able to get only the first row.
i used ExecuteReader() function of SqlCommand class and read()
function to read data..
i have put a button on the form to advance the records..
in that click method i have called the read() function...
but it's not moving to the next record...even after clicking the
button...
please help me anyone...
thanks and regards...
sandeep...
>