RETRIVING IMAGE FROM DATABASE USING FIRST NEXT PREVIOUS LAST

Question

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

chandu gummadi · Answer

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 gummadi · Answer

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 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 gummadi · Answer

i was attached my code

Nitesh Luharuka · Answer

Still waiting for code. however please explain what you mean to say by - display database records in textbox?

chandu gummadi · Answer

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 Luharuka · Answer

Please share your code.