Calculate row count

Carlos kambui

11y1.3kVisual Basic .NET

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

12 Replies

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

Saroj Kumar Sahu11y ago
Accepted 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) );
0
Rajkiran Swain11y ago
You can follow below link ....

http://techbrij.com/display-total-gridview-footer-row-linq-asp-net
0
Sreekanth Reddy11y ago
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
0
Carlos kambui11y ago
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
0
Sreekanth Reddy11y ago
Thanks for acceptance...
0
Pankaj Kumar Choudhary11y ago
hello @Carlos you can use this method:

TextBox1.Text = dataGridView1.RowCount.ToString();
0
Munesh Sharma11y ago
Int Count = datagridview.RowCount;

TextBox1.Text = Convert.ToString(Count);
0
Sreekanth Reddy11y ago
txtCount.Text = dataGridView1.RowCount.ToString();
0
Carlos kambui11y ago
how can i calculate number of student in datagridview and display in textbox
0
Munesh Sharma11y ago
As Srikanth Reddy is saying you can count no of record present in database table

select count(*) from TableName
0
Upendra Pratap Shahi11y ago
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 < dt.Columns.Count; k++)
{
total = dt.AsEnumerable().Sum(row => row.Field(dt.Columns[k].ToString()));
// if (k < dt.Columns.Count - 1)
if (k < dt.Columns.Count)
{
lineYaxis += total + ",";
lineXaxis += dt.Columns[k].Caption + ",";
}
gvStatistReport.FooterRow.Cells[k].Text = total.ToString();
gvStatistReport.FooterRow.Cells[k].Font.Bold = true;
}

0
Sreekanth Reddy11y ago
select count(*) from [table name].

produces the total number of rows.
0