Loading

need to show the row count in a gridview in runtime in asp.n

need to show the row count in a gridview in runtime in asp.n

selvi subramanian

selvi subramanian

11y1.1kLearn iOS Programming

need to show the row count in a gridview in runtime in asp.net

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

selvi subramanian11y ago
my need is like this s.no is not a bind value
Rajeesh Menoth11y ago
Hi,

Auto Generate Row Number in GridView
It is a common requirement that GridViews to have the first column just be a number identifying the row. Because of doing this implementation, the user can see the number of rows returned by scrolling to the end of the GridView. By adding a single piece of code you can add a row number column to your asp.net GridView Control.
ref:
1) http://asp.net-informations.com/gridview/row-number.htm

2) http://stackoverflow.com/questions/20154828/row-count-for-gridview-with-paging
Upendra Pratap Shahi11y ago
protected void BindGrid()

{

try
{
string sqlQry = "select * from student";
SqlCommand cmd = new SqlCommand(sqlQry, con);
cmd.CommandType = CommandType.Text;
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
sda.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
int count = GridView1.Rows.Count;
lblResult.Text = Convert.ToString(count);
}
catch (Exception ex)
{
}

}
Raja T11y ago
private void LoadGrid()
{
try
{
string sqlQry = "select * from tbl_demo";
SqlCommand cmd = new SqlCommand(sqlQry, con);
cmd.CommandType = CommandType.Text;
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
sda.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
int count = GridView1.Rows.Count;
}
catch (Exception ex)
{
}
}
Raja T11y ago
Hi,

Try this

int count = GridView1.Rows.Count;