Search code examples
c#devexpressaspxgridview

How to get count rows in AspxGridView?


I have a Gridview.I want to get count of Status=1 and Status=0 rows

    Id    Bla    Bla     Bla  Status

    1                         1 
    27                        0
    323                       1

<dx:ASPxGridView runat="server" ID="grid" Width="100%" >
            <Columns>

         some colums

         ...

         ...

</dx:GridViewDataTextColumn>
 <dx:GridViewDataTextColumn Caption="Status" FieldName="Online">
                </dx:GridViewDataTextColumn>    
        </Columns>
</dx:ASPxGridView>

How can I get counts ?

I want to display like this

  lblOnline.Text="Online Dealers : "+  countOnline.ToString();
  lblOffline.Text="Offline Dealers : "+ countOffline.ToString();

Solution

  • int countOnline = 0;
    foreach (DataRow dr in dataTable.Rows)
    {
        if (dr["Status"].Equals("1"))
        {
              countOnline++;
        }
    }
    int countOffline = dataTable.Rows.Count - countOnline;
    

    You may also extract the Status column to an ArrayList and sort the list using ArrayList.Sort and count only the first sorted 0 values.