ASP.NET

16-Aug-06 20:45

I am using c#. i have a gridview and one of the column is Category. I have used the objectdatasource to bind the data. I want to count the number of "P" exist in that column and display it at the footer of the gridview.

<br />
int presentCount = 0;<br />
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)<br />
{<br />
if (e.Row.RowType == DataControlRowType.DataRow)<br />
{<br />
//if ( # = "P")<br />
presentCount++;<br />
}<br />
else if (e.Row.RowType == DataControlRowType.Footer)<br />
{<br />
e.Row.Cells[3].Text = presentCount.ToString();<br />
}<br />
}

What whould be the correct way. What syntax should be replaced by #?
Is there any sample I can follow?

thanks in advance. Much appreciated.

coolestCoder16-Aug-06 21:09

coolestCoder

16-Aug-06 21:09

Hi,
Please check wether you can write e.Row["Category"] = "P" instead of # = "P".

I think this will help !

"A good programmer is someone who looks both ways before crossing a one-way street." -- Doug Linder

Anant Y. Kulkarni

blurMember16-Aug-06 21:19

16-Aug-06 21:19

There was an error when I compiled.

Error Cannot apply indexing with [] to an expression of type 'System.Web.UI.WebControls.GridViewRow' C:\WebSites\Attendance\Admin\frm_Report.aspx.cs 322 17 C:\WebSites\Attendance\

thanks in advance. Much appreciated.

Re: GridView [modified]

coolestCoder16-Aug-06 21:31

coolestCoder

16-Aug-06 21:31

Hi,
Sorry about that but i dont know about the GridView.
You can use the cells collection of the row -
r.Row.Cells(0) where the '0' is column number of your desired column.
I am not sure about it but you can atleast try !

check this -
http://msdn2.microsoft.com/en-us/library/system.web.ui.webcontrols.tablerow.cells.aspx[^]

"A good programmer is someone who looks both ways before crossing a one-way street." -- Doug Linder

Anant Y. Kulkarni

blurMember16-Aug-06 21:40

16-Aug-06 21:40

Thanks for the link, I have yet to understand.

Anyone there who can help? Cry | :((

Jay_se16-Aug-06 22:40

16-Aug-06 22:40

Hi Blur Member ....

u may use ," e.Row.Cells[index].Text " to get the value on that Particular Cell ( index th position, zero indexing) of the current row.

Hope It works..

Regards,

Jay

blurMember16-Aug-06 22:50

16-Aug-06 22:50

There was an error.

Error 1 Cannot implicitly convert type 'string' to 'bool' C:\WebSites\Attendance\Admin\frm_Report.aspx.cs 322 17 C:\WebSites\Attendance\

 protected void GridView4_RowDataBound(object sender, GridViewRowEventArgs e)<br />
    {<br />
        if (e.Row.RowType == DataControlRowType.DataRow)<br />
        {<br />
            if (e.Row.Cells[3].Text = "P")<br />
            {<br />
                presentCount++;<br />
            }<br />
<br />
        }<br />
        else if (e.Row.RowType == DataControlRowType.Footer)<br />
        {<br />
                e.Row.Cells[3].Text = presentCount.ToString();<br />
        }

thanks for your help so far Jay

Jay_se16-Aug-06 22:55

16-Aug-06 22:55

if (e.Row.Cells[3].Text == "P")

put '==' operator for comparision

Regards,

Jay

blurMember16-Aug-06 23:05

16-Aug-06 23:05

Basically I have a dropdownlist which filter adminNo and then display each record at the gridview. So user can see how many P exists in column Category for each adminNo.

the result display at the footer is 0.

i hope it is not due to me filtering records by dropdownlist.

jay thanks

Jay_se16-Aug-06 23:17

16-Aug-06 23:17

Whether it works or not ? You need to declare the variable 'presentCount' as a 'static' variable inorder to retain its value during the Gridview is population.

Regards,

Jay

blurMember16-Aug-06 23:31

16-Aug-06 23:31

I hope my declaration is correct.

public static int presentCount = 0;

But yet the footer still show 0.

Cry | :((

JAY THANKS

Re: GridView [modified]

Jay_se17-Aug-06 0:25

Re: GridView (Thanks Jay)

17-Aug-06 0:25

Believe me it works fine... I think , ur data "P" came from database. It may have some white spaces. use Trim() method to remove that, then the string comparision works properly.

Hope it help u...

static int count = 0;

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
string tmp=(e.Row.Cells[3].Text).Trim();

if (tmp == "P")
{
count += 1;
}
}

if (e.Row.RowType == DataControlRowType.Footer)
{
e.Row.Cells[3].Text = count.ToString();
}
}

-- modified at 6:27 Thursday 17th August, 2006

Regards,

Jay

blurMember17-Aug-06 0:42

Re: GridView (Thanks Jay)

17-Aug-06 0:42

Yes it came from a database. What an awesome solution!

Poem for Jay

I 1 2 SAY
to the person JAY
I am so GAY (happy)
to finally get the ans... Hip Hip HOORAY!

another brilliant ans from the pro.

_AK_17-Aug-06 0:48

_AK_

17-Aug-06 0:48

blurMember wrote:
I 1 2 SAY
to the person JAY
I am so GAY (happy)
to finally get the ans... Hip Hip HOORAY!

Best Regards,
Apurva Kaushal

Re: GridView (Thanks Jay)

Jay_se17-Aug-06 1:07

17-Aug-06 1:07

always welcome... Smile | :)

Regards,

Jay

blurMember17-Aug-06 16:34

17-Aug-06 16:34

When the user click from the ListBox to view each adminNo, the Show Footer manage to calculate the number of P exist in the gridview.

But when the user click another adminNo, the Show Footer number was accumulated with the previous Show Footer.

Example:
when the user click for the first time
Show Footer: 18
second output when user click for the second time, the number of P exist in the gridview is suppose to be 10, but show 38 instead
Show Footer: 38

thanks in advance. Much appreciated.

Jay_se17-Aug-06 19:39

17-Aug-06 19:39

i think the static variable 'showCount' keeps its old value. So you may declare it properly , in such a way that when u click a item from ur ListBox , the variable is set to zero.

hope it helps u

Regards,

Jay

blurMember17-Aug-06 21:53

17-Aug-06 21:53

My flu and cough is really bad, i can't even think.

Laugh | :laugh:

protected void ListBox1_SelectedIndexChanged(object sender, EventArgs e)<br />
{<br />
   count = 0;<br />
}

I did this to save my trouble. Hope no more problem.

thanks again superjay

Jay_se18-Aug-06 0:29

18-Aug-06 0:29

Regards,

Jay

Tiger45616-Aug-06 23:42

Tiger456

16-Aug-06 23:42

Try out this !.............

int presentCount = 0;
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
   YourType  obj =  e.Row.DataItem as YourType;
  if ( obj.Property = "P")
	presentCount++;
}
else if (e.Row.RowType == DataControlRowType.Footer)
{
e.Row.Cells[3].Text = presentCount.ToString();
}
}

blurMember17-Aug-06 0:11