Navigation between records using Oralce DB

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • RomeoX
    New Member
    • Jan 2010
    • 25

    Navigation between records using Oralce DB

    Hi everybody,

    Actually I'm trying to learn C# by myself, and I was thinking to create a small program, I was thinking to build 4 buttons, First, Next, Previous, Last. I'm using Oracle express database.

    I tried my best before posting here, and this is my code for next and last:

    Last_Record
    Code:
    private void last_record_Click(object sender, EventArgs e)
            {
    int i=;
    DataSet ds;
    i = ds.Tables["emp_users"].Rows.Count - 1;
    this.id.Text = ds.Tables["emp_users"].Rows[i]["id"].ToString();
    this.nom.Text = ds.Tables["emp_users"].Rows[i]["nom"].ToString();
    this.user.Text = ds.Tables["emp_users"].Rows[i]["usernom"].ToString();
    this.pass.Text = ds.Tables["emp_users"].Rows[i]["passwod"].ToString(); }

    Next_Record
    Code:
    private void next_record_Click(object sender, EventArgs e)
            {
    this.BindingContext(ds2, "emp_users").position = 0;
               this.BindingContext(ds2, "emp_users");
               da.Fill(dt);
    
               this.BindingContext[ds, "emp_users"].Position += 1;
    }

    =============== =============== ====
    Also I tried to create another code to read the row from database that is displaying in the form as follows but it doesn't work, I don't know why. could anyone have a look and tell me why,

    Code:
    private void ShowPosition()
            {
                int iCnt;
                int iPos;
                iCnt = this.BindingContext[ds, "emp_users"].Count;
                iPos = this.BindingContext[ds, "emp_users"].Position + 1;
                if (iCnt == 0)
                {
               //     this.textBox1.Text = "(No records)";
                    this.label7.Text = "(No records)";
                }
                else
                {
                    //this.textBox1.Text = iPos.ToString() + " of " + iCnt.ToString();
                    this.label7.Text = iPos.ToString() + " of " + iCnt.ToString();
                }
            }
Working...