count a word in dataGridView

Anas Albakri

4y1.2kC#

Hello how can i count a word in dataGridView like an example

i have a cars model

BMW, Audi, Mitsubishi, Mercedes .etc

i want a code to count how many bmw i have ,how many Mercedes i have. etc

in a lable.text

and i coded this

int x = 4;
label10.Text = (from Rows in dataGridView1.Rows.Cast() 
                where !Rows.IsNewRow && Rows.Cells(x).ToString == "Audi"
                select Rows).Count;

Error 1

" Non-invocable member 'System.Windows.Forms.DataGridViewRow.Cells' cannot be used like a method "

wher's the error

5 Replies

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

Amit Mohanty4y ago
Try this
int x = 4;
label10.Text = (from Rows in dataGridView1.Rows.Cast()
                where !Rows.IsNewRow && Rows.Cells[x].Value.ToString() == "Audi"
                select Rows).Count().ToString();
+2
Uday Dodiya4y ago
Please Try Followimg Code, You get Your Output And its compare LoweCase And Uppecase
count = 0
x = 4
For n As Integer = 0 To (DataGridView1.Rows.Count) - 1
    Dim str As String = DataGridView1.Rows(n).Cells(x).Value.ToString().ToLower()
    Dim car As String ="Audi"
    If str = car.ToLower()  Then
        count = count + 1
    End If
Next
label10.Text = count
+1

Sachin Singh4y ago

test this


label10.Text = (from Rows in dataGridView1.Rows.Cast() where !Rows.IsNewRow && Rows.  
Cells["x"].Value.ToString()  
 == "Audi" select Rows).Count;

Jaydeep Patil4y ago
1. https://www.aspsnippets.com/questions/209277/Count-number-of-record-for-specific-string-in-DataGridview-row-using-C-and-VBNet-in-Windows-Forms-Application/
+2
Vishal Yelve4y ago
https://www.codegrepper.com/code-examples/csharp/c%23+datagridview+count+value

var count = this.dataGridViewArticles.Rows.Cast().Count(); var countjustX = this.dataGridView1.Rows.Cast().Count(row => row.Cells["RisFin"].Value == "X");this.textBox1.Text = count.ToString();

Try this give you count.
+2