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