total number of rows in an entire gridview

Hi You need to Set Total Records when you assign DataSource to the Grid.

e.g.

int TotalRecord = dt.Rows.Count(); //This is total number of records in gridview
GridView1.DataSource = dt;
GridView1.DataBind();

Thanks,
Imdadhusen

Hi,
The easy way to get the Total count is.

1. First get the gridView DataSource. e.g

you have bind a DataSet then get the DataSet form the GridView.

like
DataSet DS = (DataSet) MygridView.DataSource;


2.Then count the no. of row in it.

like
int count = DS.Tables[0].Rows.Count;

I hope this will solve your problem.

Below is method that will return the Total number of Row.

private int GetTotalRow()
{
int Rowcount = 0;
try
{
DataSet DS = (DataSet) MygridView.DataSource;
Rowcount = DS.Tables[0].Rows.Count;
}
catch
{
throw;
}
return Rowcount ;
}

Thanks

Gridview1.Rows.Count will return the number of rows in Gridview

Here is a sample i'm providing, i've a label in a templated field at the footer.



protected void Page_Load(object sender, EventArgs e)
{

GridView1.DataSource = EmployeeByCountry("UK");
GridView1.DataBind();
Label lblFooter = GridView1.FooterRow.FindControl("lblFooter") as Label;
lblFooter.Text = GetNoOfRows().ToString();
}

You can define the function "GetNoOfRows()" using scalarquery i,e; by using COUNT() function of SQL, to get no of rows of the table.

grid.DataSource property is null!!! That way doesn't work.

My grid's datasource is an ObjectDataSource connected to a typed dataset.