How to retrieve data from a data set which is populated by a data adapter

Nov 4 2004 4:24 PM
i wanted to know how do we retrieve each row of the table populated by the data adapter , such that when we click NEXT , it goes on to the next record and PREVIOUS takes it bak to the previous record. Upon clicking , the various text boxes has to have the appropriate data Dim table As New DataTable Dim connection As New OracleClient.OracleConnection Dim command As New OracleClient.OracleCommand Dim adapter As New OracleClient.OracleDataAdapter 'set the connection connection = 'Connection String 'set command command.CommandText = "SELECT * FROM GRAD_EG " command.Connection = connection MsgBox("esablished connection") 'set dataadapter adapter.SelectCommand = command 'open connection connection.Open() 'fill table adapter.Fill(table) connection.Close() What to do after this. please help

Answers (3)