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

Question

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

selvi subramanian · Answer

my need is like this s.no is not a bind value

Rajeesh Menoth · Answer

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 Shahi · Answer

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 T · Answer

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 T · Answer

Hi, Try this int count = GridView1.Rows.Count;

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

Answers (5)