DataGridView : how to get grandtotal-? on windows form

Question

0.00/5 (No votes)

See more:

C#

i need grand total of col1 in datagridview..

thx in advance

col1
20
10
30
-----
60

Posted 3-Jan-13 0:46am

Master Vinu

Updated 3-Jan-13 1:08am

v3

Add a Solution

Comments

CHill60 3-Jan-13 6:48am

What have you tried so far - do you have any code to post?

Master Vinu 3-Jan-13 6:52am

no iam confuse how to do it?? m new to c#

Master Vinu 3-Jan-13 6:53am

private void findlaksajob_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == (char)13)
{
string sql = "SELECT [Jobcard],[Planqty],[Mouldqty],[Operator],[Supervisor],[Profilename],[Process],[Date],[Remark],[Approvedby],[id],[Division] FROM [SAPProduction].[ProductionData] WHERE JobCard ='" + findlaksajob.Text.ToString() + "'";
SqlDataAdapter da = new SqlDataAdapter(sql, objConn1);
DataSet ds = new DataSet();
objConn1.Open();
da.Fill(ds, "ProductionData");
dataGridView2.DataSource = ds;
dataGridView2.DataMember = "ProductionData";
objConn1.Close();
e.Handled = true;
}

}

Master Vinu 3-Jan-13 6:54am

using above query i get data in gridview

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Aarti Meswania · Answer 1 · 2013-01-03T01:17:00

Solution 3

while you add datasource in gridview
put a line after you assign it

C#

Dgv.AllowUserToAddRows = false;
Dgv.Rows.add();

in datagridview cell value change

C#

if (e.columnindex == 1)//column index of column you want to sum
{
    double amount = 0;
    For (i=0; i<= dgv.rows.count-2;i++)
    {
      amount += Convert.ToDouble(dgv.Row[i].Cells[1].Text.Trim());
    }
    dgv.rows[i].cells[1].value = amount.ToString();
}

Note put same code in row - deleted event also...

Happy Coding!
:)

Posted 3-Jan-13 1:17am

Aarti Meswania

Updated 3-Jan-13 1:27am

v3

Comments

Master Vinu 3-Jan-13 7:21am

i need col1 row total on end????? pls clarify me

Aarti Meswania 3-Jan-13 7:22am

end means in gridview's last row?

Master Vinu 3-Jan-13 7:23am

ya ....dynamically add on last row

Aarti Meswania 3-Jan-13 7:27am

see updated solution

Master Vinu 3-Jan-13 7:30am

private void findlaksajob_KeyPress(object sender, KeyPressEventArgs e) { if (e.KeyChar == (char)13) { string sql = "SELECT [Jobcard],[Planqty],[Mouldqty],[Operator],[Supervisor],[Profilename],[Process],[Date],[Remark],[Approvedby],[id],[Division] FROM [SAPProduction].[ProductionData] WHERE JobCard ='" + findlaksajob.Text.ToString() + "'"; SqlDataAdapter da = new SqlDataAdapter(sql, objConn1); DataSet ds = new DataSet(); objConn1.Open(); da.Fill(ds, "ProductionData"); dataGridView2.DataSource = ds; dataGridView2.DataMember = "ProductionData"; objConn1.Close(); e.Handled = true; } }

Master Vinu 3-Jan-13 7:30am

this is my code pls modify it

thx in advance

Aarti Meswania 3-Jan-13 7:36am

your code is not in proper format so i could not format it and you have to make different events and paste code as I mention. so that you have to do it your self.
I can suggest a way to do.
so select your gridview and view events take necessary events and copy-paste code inside.
:)

Master Vinu 3-Jan-13 7:40am

private void findlaksajob_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == (char)13)
{
string sql = "SELECT [Jobcard],[Planqty],[Mouldqty],[Operator],[Supervisor],[Profilename],[Process],[Date],[Remark],[Approvedby],[id],[Division] FROM [SAPProduction].[ProductionData] WHERE JobCard ='" + findlaksajob.Text.ToString() + "'";
SqlDataAdapter da = new SqlDataAdapter(sql, objConn1);
DataSet ds = new DataSet();
objConn1.Open();
da.Fill(ds, "ProductionData");
dataGridView2.DataSource = ds;
dataGridView2.DataMember = "ProductionData";
objConn1.Close();
e.Handled = true;
}

}

[no name] 3-Jan-13 7:47am

We are providing you a path to achieve your solution. You should try of your own to achieve the goal . Should not be so dependent to others.

Aarti Meswania 3-Jan-13 7:52am

you are right!
OP wants we do code for him.

Master Vinu 3-Jan-13 7:41am

pls make changes in above query

Aarti Meswania 3-Jan-13 7:44am

Note : replace dgv with dataGridView2.

private void findlaksajob_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == (char)13)
{
string sql = "SELECT [Jobcard],[Planqty],[Mouldqty],[Operator],[Supervisor],[Profilename],[Process],[Date],[Remark],[Approvedby],[id],[Division] FROM [SAPProduction].[ProductionData] WHERE JobCard ='" + findlaksajob.Text.ToString() + "'";
SqlDataAdapter da = new SqlDataAdapter(sql, objConn1);
DataSet ds = new DataSet();
objConn1.Open();
da.Fill(ds, "ProductionData");
dataGridView2.DataSource = ds;
dataGridView2.DataMember = "ProductionData";
objConn1.Close();

Dgv.AllowUserToAddRows = false;
Dgv.Rows.add();

double amount = 0;
For (i=0; i<= dgv.rows.count-2;i++)
{
amount += Convert.ToDouble(dgv.Row[i].Cells[1].Text.Trim());
}
dgv.rows[i].cells[1].value = amount.ToString();

e.Handled = true;
}

}

Master Vinu 3-Jan-13 7:46am

where is column name

Aarti Meswania 3-Jan-13 7:50am

I am not doing code for you
I think that you are a newbie so, may you are not familiar with event's of gridview
you know the column names missing so do it your self.

shiny13 · Answer 2 · 2013-01-03T01:16:00

Solution 2

You can take an object of DataGridView and in a foreach loop you can loop through each row and keep adding them to the total amount.

C#

DataGridView dgv = dataGridView1;
int amount = 0; //maybe you can use double if that is what you need

foreach (DataGridViewRow row in dgv)
{
    amount += Convert.ToInt32(row.Amount);
}

//After the loop ends

Posted 3-Jan-13 1:16am

shiny13

Updated 3-Jan-13 2:19am

v2

Comments

Master Vinu 3-Jan-13 7:19am

i need col1 row total on end????? pls clarify me

shiny13 3-Jan-13 8:23am

well a column means that it will be be NEXT to the amount column, so you have to add another column. But I think according to your example in the question you are looking for a Row in the end that is the sum of all rows. So after the loop ends add make a DataGridViewRow object and then add the amount value then in the existing dataGridView just add your row!

Prasad_Kulkarni · Answer 3 · 2013-01-03T00:59:00

Try:

C#

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
        double amount = 0;
        //Check the RowType of the specific row
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            amount += Convert.ToDouble(e.Row.Cells[1].Text.Trim());
            GridView1.FooterRow.Cells[1].Text = amount.ToString("#,###.00");
        }
 }

DataGridView : how to get grandtotal-? on windows form

3 solutions

Solution 3

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us