count a word in dataGridView

Question

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<DataGridViewRow>() 
                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

Amit Mohanty · Answer

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();

Sachin Singh · Answer

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

Uday Dodiya · Answer

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

Jaydeep Patil · Answer

https://www.aspsnippets.com/questions/209277/Count-number-of-record-for-specific-string-in-DataGridview-row-using-C-and-VBNet-in-Windows-Forms-Application/

Vishal Yelve · Answer

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.

count a word in dataGridView

Answers (5)