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 orderi also to auto add row to datagridview showing numbers that is 2001 1802 1503 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.