RETRIVING IMAGE FROM DATABASE USING FIRST NEXT PREVIOUS LAST

chandu gummadi

12y1.5k.NET

HI IAM DEVELOPING APPLICATION DISPLAY IMAGE FROM DATABASE USING FIRST NEXT PREVIOUS LAST BUTTONS

I WRITEN THE CODE BUT BUT IT WORKS PROPERLY FOR FIRST NEXT BUTTONS
ITS NOT WORKING WITH PREVIOUS NEXT BUTTONS HERE IS MY CODE PLEASE HELP ME FRIENDS

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

chandu gummadi12y ago
here when iam clicking next button it display next record first time only again iam clicking next button it displays same record.because here rno is not increased and every time rno takes zero only
chandu gummadi12y ago
cmd.CommandText = "select * from customerr"
Dim da As New SqlDataAdapter
Dim dt As New DataTable
da.SelectCommand = cmd
cmd.Connection = connection
da.Fill(dt)
If rno < dt.Rows.Count - 1 Then
rno += 1
If dt.Rows.Count > "0" Then
txtcustid.Text = dt.Rows(rno)(0).ToString()
txtcustname.Text = dt.Rows(rno)(1).ToString()
txtcustaddress.Text = dt.Rows(rno)(2).ToString()
If dt.Rows(rno)(3) IsNot Nothing Then
photo_aray = DirectCast(dt.Rows(rno)(3), Byte())
photo_aray = dt.Rows(rno)(3)
image1.ImageUrl = "data:image/png;base64," & Convert.ToBase64String(photo_aray) End If End If End If
chandu gummadi12y ago
i was attached my code
Nitesh Kejriwal12y ago
Still waiting for code. however, please explain what you mean to say by - display database records in textbox?
chandu gummadi12y ago
hi friend my image is displayed in the image control from database but i want to display database records in textboxes using first next previous last buttons i tried but it works only for first last buttons.when i click previous button it does not display previous image or data

here is my code please help me
Nitesh Kejriwal12y ago
Please share your code.