Record cound from datagridview , or datadet

Question

can some one post a sample code up where in you can get a record count in the datagridview

from a speacify item under a column or a row.

for example

id         a           b          c

--------------------------------
1   |      f      |       t     | u
     |             |             |
2   |     f       |      w |    t

How can i find f is populated under column a.
this is the record count im trying to do

3       r              e           r

David Smith · Answer

Im not for sure if you guys are familiar with pivot table in access. What I want to do is create a table . This table is going to be a record count, which im going to send to a datagridview. So my question base on the datagridview1, is there a way to just simply get a record and import to datagridview2 from the raw data thats in datagridview1. I posted my datagridview1 in a picture so you can see whats going on. Now in the datagridview one im only curious of how many Etags occur per UutMSN. so in my datagridview2 table which is going to be the record count table of occured etags The etags that occur are going to be columns headers so my table2 design is going to be set up like this below UutMSN F000 F001 3757 etc................. 2261MSN 3 1 2 1368MSN 0 3 1 3445MSN 3 2 0 This is a example of the recordcount table recording how many times each Etag occured F000 , F001 3757 are etags, if you look in the file i attach below you will see what im talking about Can someone assist me

Sam Hobbs · Answer

I think it is possible to write a SQL query that returns just a record count. You say "this method works" and show some code, but then you say you want to "get the actual number", so I am confused; does that code do what you need or not?

David Smith · Answer

Is there a way to do a pivot data report with datagridview like you can do in access?

David Smith · Answer

sorry about the post you guys this method works. sEtagCount = "a"; BindingSource.Filter = "Etag like '%" + sEtagCount + "%'"; return cIFCLUOpDataBindingSource.Count; something like this, its like a filter , but i want to get the actual number , because im going to send the number to another table , is there a easy way to do this besides how i am doing this , to just count how many times "a" is display in a table. I only need the number

David Smith · Answer

sorry about the post you guys this method works. sEtagCount = "a"; BindingSource.Filter = "Etag like '%" + sEtagCount + "%'"; return cIFCLUOpDataBindingSource.Count; something like this, its like a filter , but i want to get the actual number , because im going to send the number to another table , is there a easy way to do this besides how i am doing this , to just count how many times "a" is display in a table. I only need the number

Record cound from datagridview , or datadet

Peter

Manish Dwivedi