How to display the record and use NEXT and Prev buttons?

Question

Please help me I don't know who else to ask or go for help to: I want to display a RAND_ID (which is just an id in my table) but when the user presses button next I want to show next ip in the row. My code: BindingManagerBase bmStud; OracleConnection conn; try { conn = new OracleConnection(User Id=system;Password=serv123;Data Source=;); conn.Open(); DataAdpt = new OracleDataAdapter(SELECT * FROM info conn); CmdBuild = new OracleCommandBuilder(DataAdpt); DataSet1 = new DataSet(info); DataTable1 = new DataTable(info); DataAdpt.Fill(DataSet1info); bmStud = this.BindingContext[DataSet1 info]; // How can I do what I asked for >> conn.Close(); } catch(Exception ex) { MessageBox.Show(There was some error connecting to the database. DB Error MessageBoxButtons.OK MessageBoxIcon.Error) ; }

monkey_gold2003 · Answer

yes i know it with VB.net. You aleady have binding dataset to go next you move to right position you want by method bindingconext(dataset Table).position = ? it ok. Good luck

jcity444 · Answer

Not exactly sure what you are asking. You can display anything you want in the DataSet just by cycling through the rows. if you want to make sure that you get the next sequence by a certain ID you may want to add ORDER BY RAND_ID to your query. Then make the DataSet a member of your class. Then create a button in your form double click on it and fill the event handler with something that gets the next row. Increment a counter for a row each time and pull the data out of the row. With Previous Decrement the counter. int _rowPointer = 0; DataSet _dataSet; void Initialize() { BindingManagerBase bmStud; OracleConnection conn; try { conn = new OracleConnection(User Id=system;Password=serv123;Data Source=;); conn.Open(); DataAdpt = new OracleDataAdapter(SELECT * FROM info ORDER BY RAND_ID conn); CmdBuild = new OracleCommandBuilder(DataAdpt); _dataSet = new DataSet(info); DataTable1 = new DataTable(info); DataAdpt.Fill(DataSet1info); bmStud = this.BindingContext[DataSet1 info]; // How can I do what I asked for >> // check the button event conn.Close(); } catch(Exception ex) { MessageBox.Show(There was some error connecting to the database. DB Error MessageBoxButtons.OK MessageBoxIcon.Error) ; } } private void btnPrevious_Click(object sender System.EventArgs e) { _rowPointer--; if (_rowPointer < 0) { _rowPointer = 0; } MessageBox.Show (Row Id =  + _dataSet.Tables[0].Rows [_rowPointer][RAND_ID].ToString()); }