gridview lable print on gridview

Question

0.00/5 (No votes)

See more:

i have table in table tb1 like(table only one clounm)
ID
100
200
300
100
200
200
i used this query
select ID, count(ID) as pair From tb1 group by MemberID HAVING Count(ID)>0
i got result
id pair
100 2
200 3
300 1
i need result like this in gridview

ID pair
100 2
200 3
300 1

i write this code in rowdatbound

C#

protected void gridtree_RowDataBound(object sender, GridViewRowEventArgs e)
   {
if (e.Row.RowType == DataControlRowType.DataRow)
        {
            Label lblmessage = (Label)e.Row.FindControl("lblmessage");

            if (dt.Rows.Count > 0)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    lblmessage.Text = dt.Rows[i]["pair"].ToString();
                  

                }
            }
        }
   }

I am getting this result
ID pair
100 1
200 1
300 1

I need result

Id pair
100 2
200 3
300 1

Posted 9-Apr-12 4:11am

rajnish singh rathor

Updated 9-Apr-12 4:28am

Ankur^\m/

v2

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

VJ Reddy · Answer 1 · 2012-04-09T05:41:00

As seen from the following code given in the question,

C#

for (int i = 0; i < dt.Rows.Count; i++)
{
    lblmessage.Text = dt.Rows[i]["pair"].ToString();
}

each time the gridtree_RowDataBound event is fired, all rows of the DataTable dt are traversed in the for loop and the lblmessage.Text is set, which is being over written in each iteration. So the last value in the last row of the DataTable dt, which is 1 as seen from the data given in the question, will be visible in the lblmessage after the above event.
But I think, for the purpose of displaying the data in GridView a DataTable with columns Id, pair can be created and populated as per requirement. Then it can be used to bind to the gridview in a normal way. You can consider this alternative.

nika2008 · Answer 2 · 2012-04-09T08:08:00

Solution 2

try this query

Select ID , (select count(tabel1.ID) from tabel1
where tabel1.ID = tabel.ID
HAVING Count(tabel1.ID)>0 )
from tabel

and u dont need to check for if (dt.Rows.Count > 0)

Posted 9-Apr-12 8:08am

nika2008

Comments

rajnish singh rathor 10-Apr-12 2:19am

thanks..but i got another way

rajnish singh rathor · Answer 3 · 2012-04-09T20:25:00

just take gidview like this only

XML

<asp:GridView ID="gridtree1" runat="server" AutoGenerateColumns="false"
                          Width="100%" height="50%"
               OnRowDataBound="gridtree_RowDataBound" style="margin-top: 3px" >

                            <Columns>
                            <asp:BoundField ReadOnly="true" HeaderText="ID" DataField="MemberID" SortExpression="MemberID" />
                            <asp:BoundField ReadOnly="true" HeaderText="pair" DataField="pair" SortExpression="pair" />
<%--                            <asp:BoundField ReadOnly="true" HeaderText="award" DataField="pair" SortExpression="pair" />--%>
                             <asp:TemplateField HeaderText="Award" SortExpression="Pair">
                                 <ItemTemplate>
                                  <asp:Label ID="lblmessage" runat="server"> </asp:Label>
                                </ItemTemplate>
                               </asp:TemplateField>

                             </Columns>
                              </asp:GridView>

gridview lable print on gridview

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0