How to increment textbox when data is adding

Question

1.00/5 (1 vote)

See more:

I'm new to C#
I want to increment textbox when data from another table is adding .when i'm doing even after closing them number increases

What I have tried:

(data is in dataReader)

C#

string val = dataReader[0].ToString();
 int value = int.Parse(dataReader[0].ToString()) + 1;
 textBox3.Text = value.ToString();

Posted 23-May-21 20:45pm

Member 15212425

Updated 23-May-21 22:45pm

RickZeeland

v2

Add a Solution

Comments

Richard MacCutchan 24-May-21 3:55am

Not enough context in your question, as you have not shown how and when this code is invoked.

1 solution

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)

OriginalGriff · Answer 1 · 2021-05-23T22:45:00

If you are trying to do a sum in a text box, then start by not using a DataReader - they are sequential and only allow you to process through the results in order: you can't "rewind" and go back.
Instead, consider using a DataAdapter to file a DataTable (if you are accessing information from a DB for example) or a DataTable directly, and then use that to calculate your totals.

C#

using (SqlConnection con = new SqlConnection(strConnect))
    {
    con.Open();
    using (SqlDataAdapter da = new SqlDataAdapter("SELECT MyColumn1, MyColumn2 FROM myTable WHERE mySearchColumn = @SEARCH", con))
        {
        da.SelectCommand.Parameters.AddWithValue("@SEARCH", myTextBox.Text);
        DataTable dt = new DataTable();
        da.Fill(dt);
        myDataGridView.DataSource = dt;
        }
    }

If you keep numeric values in your DB, they will arrive in your DataTable as numbers as well.
Then the calculation is simple:

C#

int total = 0;
foreach (DataRow row in dt.Rows)
    {
    total += (int)row[0];
    }
myTextBox.Text = total.ToString();