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

s_zel_s

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(DataSet1,"info"); 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) ; }

2 Replies

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

monkey_gold200321y ago
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
0
jcity44421y ago
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(DataSet1,"info"); 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()); }
0