coding a Next button to advance to next row of data table

Scott G

I have a form with two panels. A button click makes my second panel visible which has several textboxes bound to a database through the use of a DataTable and SqlDataAdapter.

private void btnViewAgents_Click(object sender, EventArgs e)

{

pnlAgents.Visible = true;

SqlCommand SelAgts = new SqlCommand("SELECT * FROM myTable ORDER BY last_name", misc);

DataTable dt = new DataTable();

SqlDataAdapter da = new SqlDataAdapter(SelAgts);

da.Fill(dt);

misc.Open();

txtLName.Text = dt.Rows[0]["last_Name"].ToString();

txtFName.Text = dt.Rows[0]["first_name_mi"].ToString();

txtAgt.Text = dt.Rows[0]["agency_use"].ToString().Substring(0, 5);

txtStore.Text = dt.Rows[0]["agency_use"].ToString().Substring(6, 19);

...

misc.Close();

}

I now have two other buttons on this panel, next and previous that I need to have move to the next or previous row in the table. So basically on the next button click I need each textbox to advance from row 0 to 1 and so on with each click.

5 Replies

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

Dorababu Meka8y ago
Accepted answer
If it is a winforms initially declare
int index = 0;
Then on your next and previous buttons
private void next_Click(object sender, EventArgs e)
{
    if (index < datatable.rows.count- 1)
    {
        index += 1;
        textBox1.Text = datatable.rows[index]["column"].ToString();
    }
}

private void previous_Click(object sender, EventArgs e)
{
    if (index > 0)
    {
        index -= 1;
        textBox1.Text = datatable.rows[index]["column"]ToString();
    }
}
Dorababu Meka8y ago
Glad it helps :)
Scott G8y ago
Nevermind. I am an idiot.
Scott G8y ago
Thanks for the reply. Thats exactly what I tried and it isn't working. Nothing is actually happening.

int index = 0;
int maxRows = dt.Rows.Count;
if (index <= maxRows - 1)
{
index += 1
txtLName.Text = dt.Rows[index]["last_Name"].ToString();
txtFName.Text = dt.Rows[index]["first_name_mi"].ToString();
txtAgt.Text = dt.Rows[index]["agency_use"].ToString().Substring(0, 5);
txtStore.Text = dt.Rows[index]["agency_use"].ToString().Substring(6, 19);
...
...
}
Dorababu Meka8y ago
Is it winforms or webforms? If I understad correctly you have a datatable with rows and on next click you need to get the next row data and so on