C#, row count in datagridview on button click

Question

I have an inventory application that displays the information in datagridview after entering a part number in a textbox and clicking a search button. My question is, how do I count the rows that are displayed and put the count in a textbox? Below is my code to display the rows that relate to the part number entered.

  private void searchPartbtn_Click(object sender, EventArgs e)
    {
        if (!string.IsNullOrEmpty(partSearch.Text))
        {
            try
            {
                connection.Open();

                OleDbCommand command = new OleDbCommand();
                command.Connection = connection;
                string query = "SELECT * FROM Inventory WHERE PartNumber='" + partSearch.Text + "'";
                command.CommandText = query;

                connection.Close();
                OleDbDataAdapter db = new OleDbDataAdapter(command);
                DataTable dt = new DataTable();
                db.Fill(dt);
                dataGridFB.DataSource = dt;

            }

            catch (OleDbException ex)
            {
                MessageBox.Show(ex.Message);
                connection.Close();
            }
            searchHide();
            connection.Close();
        }
    }

Use could use dt.Rows.Count which gives you count.

Hari Prasad
– Hari Prasad

2016-05-27 02:26:39 +00:00
Commented May 27, 2016 at 2:26 — Hari Prasad
– Hari Prasad, Commented May 27, 2016 at 2:26

Alastair Brown · Accepted Answer · 2016-05-27 02:26:28Z

3

Try this at the bottom of the try block:

TextBoxField.Text = dt.Rows.Count.ToString();

answered May 27, 2016 at 2:26

Alastair Brown

1,6169 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Shon · Accepted Answer · 2016-05-27 02:26:43Z

0

Use e.rowindex which will tell you the index of the selected row. If you are using button then you will need to use a global variable to determine which row has been selected.

answered May 27, 2016 at 2:26

Shon

4864 silver badges9 bronze badges

Collectives™ on Stack Overflow

C#, row count in datagridview on button click

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related