Record cound from datagridview , or datadet

David Smith

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

5 Replies

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

David Smith16y ago
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 Hobbs16y ago
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 Smith16y ago
Is there a way to do a pivot data report with datagridview like you can do in access?
David Smith16y ago
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 Smith16y ago
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