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

vishalsethia

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

3 Replies

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

m3lles22y ago
you can make use of the BindingManagerBase class to bind have a more flexible control to the dataset..you can reference the records using the property Position of the class. BindingManagerBase bmStud; adapMain.Fill(dsMain,"Student"); bmStud=this.BindingContext[dsMain,"Student"]; add eventhandler for the nanviagtion buttons you created.. to move next bmStud.Position +=1; to move previous : bmStud.Position -=1; to move first: bmStud.Position=0; to move Last: bmStud.Position=bmStud.Count -1; as long as the controls used to display the data (textboxes..) are binded to the dataset..you would notice the moving of records.. hope this helps....
vishalsethia22y ago
hello Mahesh, thanx a lot for ur help. sorry for not responding these days as i was held in my examinations
Mahesh Chand22y ago
A DataTable object is a collection of DataRow objects. You can retrieve all rows using DataTable.Rows property, which returns a DataRowCollection. You can loop through these rows using DataRow object. Here is the code: foreach (DataRow row in table.Rows) { string str = row["ColumnName"]; } If you dont know column name, you can use column index. str = row[0];