Calculate row count

Question

calculate row count in datagridview with student table i want to calculate total numbers of student in class

Saroj Kumar Sahu · Answer

Hi, If the property AllowUsersToAddRow is set to true then Use TextBox1.Text=Convert.ToString((DataGridView1.RowCount-1) ); else Use TextBox1.Text=Convert.ToString((DataGridView1.RowCount) );

Rajkiran Swain · Answer

You can follow below link .... http://techbrij.com/display-total-gridview-footer-row-linq-asp-net

Srikanth Reddy · Answer

For 1st) try to retrieve the data in select.... order by marks desc. For another autoincrement column) Follow this: http://www.quadtechindia.com/our_forum/index.php?topic=71.0

Carlos kambui · Answer

in the same table i have marks row ,i want to arrange mark row in ascending order,i also to auto add row to datagridview showing numbers that is 200,1 180,2 150,3 is it possible

Srikanth Reddy · Answer

Thanks for acceptance...

Pankaj Kumar Choudhary · Answer

hello @Carlos you can use this method: TextBox1.Text = dataGridView1.RowCount.ToString();

Munesh Sharma · Answer

Int Count = datagridview.RowCount; TextBox1.Text = Convert.ToString(Count);

Srikanth Reddy · Answer

txtCount.Text = dataGridView1.RowCount.ToString();

Carlos kambui · Answer

how can i calculate number of student in datagridview and display in textbox

Munesh Sharma · Answer

As Srikanth Reddy is saying you can count no of record present in database table select count(*) from TableName

Upendra Pratap Shahi · Answer

Set fotter='true' and then int total = 0; ; gvStatistReport.FooterRow.Cells[1].Text = "Total"; gvStatistReport.FooterRow.Cells[1].Font.Bold = true; gvStatistReport.FooterRow.Cells[1].HorizontalAlign = HorizontalAlign.Left; for (int k = 2; k { total = dt.AsEnumerable().Sum(row => row.Field (dt.Columns[k].ToString())); // if (k if (k { lineYaxis += total + ","; lineXaxis += dt.Columns[k].Caption + ","; } gvStatistReport.FooterRow.Cells[k].Text = total.ToString(); gvStatistReport.FooterRow.Cells[k].Font.Bold = true; }

Srikanth Reddy · Answer

select count(*) from [table name]. produces the total number of rows.

Calculate row count

Answers (12)