How to Count Records in GridView

Question

0.00/5 (No votes)

See more:

Hi,My Question is

How to Count Records in GridView,I took one link button & text of linkbutton is applicants,but i want number of applicants(count applicants)should be display instead of writing applicants.

Coding
UI Code

C#

public partial class Job_Response : System.Web.UI.Page
{
    static DataTable dt;
    ResponseDetail_select responseobj = new ResponseDetail_select(ConfigurationManager.ConnectionStrings["portal"].ConnectionString);
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            dt = responseobj.get_response_job(cmp_id);
            GridView1.DataSource = dt;
            GridView1.DataBind();
        }
    }
}

Class.cs

C#

public DataTable get_response_job(int cmp_id)
{
  return (dl.GetDataTable("select job_id,job_title from Recruiter_JobPost where company_id='" + cmp_id + "'"));
}

Source Code

ASP.NET

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
                DataKeyNames="job_id" onselectedindexchanged="GridView1_SelectedIndexChanged" 
                Height="204px" Width="819px" onrowcommand="GridView1_RowCommand" 
                BorderColor="#0099FF" BorderStyle="Outset" CellPadding="4" ForeColor="#333333" 
                GridLines="None" style="margin-left: 85px" >
        <alternatingrowstyle backcolor="White" />
        <columns>
<asp:BoundField DataField="job_title" HeaderText="Job Title" SortExpression="job_title" />
            <asp:TemplateField HeaderText="No of Applicants" SortExpression="total_applicants">
                
                <itemtemplate>
                    <asp:LinkButton ID="LinkButtonApp" runat="server" CommandName="App" CommandArgument='<%#Eval("job_id")%>' >Applicants
                </itemtemplate>
            
</columns>

Posted 2-Apr-13 8:30am

Inderveer kaur

Updated 2-Apr-13 9:06am

Chris Maunder772.8K

v3

Add a Solution

3 solutions

Solution 4

http://forums.asp.net/t/986566.aspx[^]

Posted 6-Apr-13 2:36am

Rekhash

Solution 1

I would try something like this:

int i = 0;

foreach(DataRow dr in dt.Rows)
{
    i++;
}

It is just a simple way to count the rows that will be filling your GridView.

Posted 2-Apr-13 8:35am

Richard C Bishop

Comments

Maciej Los 2-Apr-13 15:15pm

What's for go thru the collection of rows? See my answer.

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)

Maciej Los · Accepted Answer · 2013-04-02T09:13:00

Solution 2

If you bind DataTable (dt) to your GridView, you can use Rows.Count property for dt.

C#

Label1.Text = "Rows count: " + dt.Rows.Count.ToString();

Simple?

Posted 2-Apr-13 9:13am

Maciej Los

Comments

Richard C Bishop 2-Apr-13 15:16pm

That is way better than my solution. How could I have forgot about that property when I use it all the time.

Maciej Los 2-Apr-13 15:18pm

Sometimes it happens ;)

Sergey Alexandrovich Kryukov 2-Apr-13 18:16pm

5ed.
—SA

Maciej Los 3-Apr-13 1:36am

Thank you, Sergey ;)