Count label and compare number in [C#]

Question

0.00/5 (No votes)

See more:

I build a Work management software and am having a small problem as follows:

I have a label "Hard work" display and 1 Data_Gird_view , I want to show the form if there is line >= 30 in column "Total Time" then label "Hard work" +1

If there are 4 lines >= 30 then label "Hard work" +4

But I don't know which string will compare an integer with a column in Data_Gird_view. Everyone please help or suggest me

Please see the picture below to understand what I mean

https://ibb.co/qJLQ1fh

As shown in the picture above. in column "Total Time" I have 4 rows greater than 30. so I want label HarkWork = 4

What I have tried:

<pre>db.fillDataGridView("select * from [tbl_RequestSMT]", dataGridView1);
            
            IEnumerable<DataGridViewRow> rows = dataGridView1.Rows

         .Cast<DataGridViewRow>()
         .Where(r => r.Cells["TotaTime"].Value.ToString().Equals("30"));


            if (rows.Count() == 0)
            {
                // Not Found .
                
            }

            else
            {
                // Found
                // if label "Hard Work ++"  but i don't know code here :(

                
            }

Posted 22-Oct-20 7:47am

Sơ Mi Tv

Updated 23-Oct-20 10:25am

v3

Add a Solution

Comments

BillWoodruff 23-Oct-20 0:35am

the picture link does not work

Sơ Mi Tv 23-Oct-20 14:14pm

You can copy and paste new tag browser

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)

BillWoodruff · Answer 1 · 2020-10-22T19:04:00

Solution 3

 // assume the Label is named 'lblHardWorkCount

const string HardWorkLabelText = "Hard Work Count: {0}";
const int HardWorkThreshold = 30;

// to be executed in some method or event handler:

IEnumerable<DataGridViewRow> rows = dataGridView1.Rows.Cast<DataGridViewRow>().Where(r => ((Int32) r.Cells["TotalTime"].Value) >= HardWorkThreshold);

lblHardWorkCount.Text = string.Format(HardWorkLabelText, rows.Count());

Note: I suggest you wrap this in a try-catch block while developing in case you have bad data.

Posted 22-Oct-20 19:04pm

BillWoodruff

Updated 23-Oct-20 2:20am

v3

Comments

Sơ Mi Tv 23-Oct-20 9:29am

I've try code but not run. errors appear:
'System.InvalidCastException: 'Specified cast is not valid.'

I try breackpoint > IEnumerable<datagridviewrow> rows = dataGridView1.Rows.Cast<datagridviewrow>().Where(r => ((int)r.Cells["TotalTime"].Value) == HardWorkThreshold);

results return: rows null

BillWoodruff 23-Oct-20 9:47am

the code you show is not the same as the code i posted: i verified that code running against a DataGridView with a Column of Type Int32.

Is the Column named "Total Time," or "TotalTime" ?

Sơ Mi Tv 23-Oct-20 9:54am

Columns in my Datagirdview name "TotalTime" or [07]. I tried 2 name but not run

Sơ Mi Tv 23-Oct-20 10:00am

I also tried your code but the results are still the same

BillWoodruff 23-Oct-20 10:43am

then you need to examine the structure of your DataGridView carefully. do you have an integer column named "TotalTime" ?

put breakpoints in your code and single step through it: identify exactly where the error occurs.

i guarantee you the code i posted works !

Sơ Mi Tv 23-Oct-20 16:29pm

I update code below,please see and help me fix it
special thanks!

Gerry Schmitz · Answer 2 · 2020-10-22T11:27:00

Solution 1

Just show the "total lines" and the number / index of the current / selected line; e.g. "15 of 34". (If the user resizes the screen, your calcs go off anyway).

Posted 22-Oct-20 11:27am

Gerry Schmitz

Comments

Sơ Mi Tv 22-Oct-20 18:15pm

I have label total lines already. But I need show difficult work in other label (if on columns Total Time have columns >= 30, labels "Hard Work ++")

Sơ Mi Tv · Answer 3 · 2020-10-23T10:26:00

Below source code use in project. please see and help me fix it:
Images:
https://ibb.co/ssP8VqG
https://ibb.co/dGjFFwp
(Please copy and paste new tag browse)

public void BtnSearch_Click(object sender, EventArgs e)

       {
           db = new DbConnector();
           lbTotal.Text = "00";

           db.fillDataGridView("select *from tbl_WorkLoad where TimeComplete Between'" + dateTimePicker1.Value.ToString("dd-MM-yy| HH:mm:tt") + "' and '" + dateTimePicker2.Value.ToString("dd-MM-yy| HH:mm:tt") + "'", dataGridView1);
           const string HardWorkLabelText = "Hard Work Count: {0}";
           const int HardWorkThreshold = 30;

           try
           {
               IEnumerable<DataGridViewRow> rows = dataGridView1.Rows.Cast<DataGridViewRow>().Where(r => ((Int32)r.Cells["TotalTime"].Value) >= HardWorkThreshold);

               lbHardwork.Text = string.Format(HardWorkLabelText, rows.Count());

               {
                   for (int i = 0; i < dataGridView1.Rows.Count; i++)
                   {
                       lbTotaltime.Text = (Convert.ToString(double.Parse(lbTotaltime.Text) + double.Parse(dataGridView1.Rows[i].Cells[7].Value.ToString())));

                   }

                   {
                       int iCount = 0;
                       for (int i = 0; i <= dataGridView1.RowCount - 1; i++)
                       {
                           if (dataGridView1.Rows[i].Cells[0].Value != null)
                           {
                               //if ((bool)dataGridView1.Rows[i].Cells[0].Value)
                               //{

                               //}
                               iCount++;
                               lbTotal.Text = iCount.ToString();
                           }
                           else continue;
                       }

                   }
               }
           }
           catch (Exception ex)
           {

               MessageBox.Show(ex.Message.ToString());
           }
       }

Count label and compare number in [C#]

3 solutions

Solution 3

Solution 1

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us