Counting rows in datagridview using c#

Question

I used following code to count datagrid rows, but it works on button only. I want the total number of rows in a textbox, but it doesn't increment itself as the number of rows increase.

int numRows = dataGridView1.Rows.Count;

txtTotalItem.Text = numRows.ToString();

So you want the number in the textbox to change automatically when rows are added/removed rather than when you click a button? Just use the RowsAdded and RowsRemoved events to change the textbox. — Equalsk
– Equalsk, Commented Dec 18, 2015 at 16:57
should i use RowsAdded or RowsRemoved in textchanged property of textbox? — Rana Rashid
– Rana Rashid, Commented Dec 18, 2015 at 16:59

Mihai-Daniel Virna · Accepted Answer · 2015-12-18 17:10:46Z

12

When you assign the number, the textbox will display only that number, it will not update.

You can use an event and assign the new number to the textbox.

dataGridView1.RowsAdded+=(s,a)=>OnRowNumberChanged;

private void OnRowNumberChanged()
{
    txtTotalItem.Text = dataGridView1.Rows.Count.ToString();
}

Following Equalsk's answer, you need to have the event for removed rows as well. You can subscribe to both events with the same function since you need to just check the number.

dataGridView1.RowsRemoved+=(s,a)=>OnRowNumberChanged();

edited Dec 18, 2015 at 17:10

answered Dec 18, 2015 at 16:59

Mihai-Daniel Virna

9949 silver badges20 bronze badges

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

1 Comment

Equalsk Over a year ago

Upvote for subscribing to both at the same time, much neater than mine

Community · Accepted Answer · 2018-07-24 01:55:38Z

4

If I've understood your question correctly you want the TextBox value to change automatically when rows are added or removed because at the moment you have to press a button to refresh. Am I right?

If so just subscribe to the .RowsAdded and .RowsRemoved events and update the TextBox from there.

dataGridView1.RowsAdded += RowsAdded;
dataGridView1.RowsRemoved += RowsRemoved;

private void RowsAdded(object sender, DataGridViewRowsAddedEventArgs e)
{
    txtTotalItem.Text = dataGridView1.Rows.Count.ToString();
}

private void RowsRemoved(object sender, DataGridViewRowsRemovedEventArgs e)
{
    txtTotalItem.Text = dataGridView1.Rows.Count.ToString();
}

edited Jul 24, 2018 at 1:55

CommunityBot

11 silver badge

answered Dec 18, 2015 at 17:01

Equalsk

8,2643 gold badges47 silver badges71 bronze badges

3 Comments

Rana Rashid Over a year ago

all answers works fine but following code was generating error. and after removing that line. rest of code works as it supposed to be. dataGridView1.RowsAdded += RowsAdded;

Rana Rashid Over a year ago

why this code(dataGridView1.RowsRemoved+=dataGridView1_RowsRemoved;) was used because this( txtTotalItem.Text = dataGridView1.Rows.Count.ToString(); ) is still working even after removing that

Equalsk Over a year ago

Rows removed would update the text box if rows were removed. It might be that you never remove rows and therefore don't need it.

roudlek · Accepted Answer · 2022-05-15 18:01:24Z

0

the datagridview will count the last empty row so make sure to

look for AllowUserToAddRows property of datagridview and set it to False.

Or add this to your code, in my case i used a label and i named it labelTotalResult, do this if you want to keep the property as true

                    labelTotalResult.Text = (dataGridView1.RowCount - 1).ToString();

answered May 15, 2022 at 18:01

roudlek

3952 silver badges11 bronze badges

Collectives™ on Stack Overflow

Counting rows in datagridview using c#

3 Answers 3

1 Comment

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related