Two buttons: "Back" and "Next"

Hi!

I need to scroll my datas with these buttons ("Back" and "Next"). With these codes how can I scrolling my datas showing on my textboxes.

conn = new OleDbConnection(connstr);

comm = new OleDbCommand();

conn.Open();

OleDbParameter date = new OleDbParameter("@date", SqlDbType.VarChar);

OleDbParameter cod = new OleDbParameter("@cod", SqlDbType.VarChar);

OleDbParameter name = new OleDbParameter("@name", SqlDbType.VarChar);

comm.Parameters.Add(date);

comm.Parameters.Add(cod);

comm.Parameters.Add(name);

date.Value = dateTimePicker2.Text;

cod.Value = txtCode.Text;

name.Value = txtWork.Text;

comm.Connection = conn;

comm.CommandText = "insert into power ([date],[cod],[name]) values(@date,@cod,@name)";

try

{

comm.ExecuteNonQuery();

MessageBox.Show("Saved...");

}

catch (Exception ex)

{

MessageBox.Show(ex.Message);

}

finally

{

conn.Close();

2 Replies

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

Mfwamba Tshimanga11y ago
I could weel put the codes. But I dont have that why I put these codes to give an idea on my "plan".
Afzaal Ahmad Zeeshan11y ago
Where actually is the code for your buttons? This is just a connection code and the commands are being executed.