How can I automatically increment numbers in C#?

Question

I am using C# 2008 Windows Forms application.

In my project there is a TextBox control and in that I want make an auto generate numbers for samples s00, next when I come back to form again it should be increment like s01,s02,s03......like that

Please help me

score 7 · Answer 1 · edited Feb 04 '11 at 11:59

7

Quite easy. Keep a variable to keep the current number.

int incNumber = 0;

Then on click of button, generate the number string like this:

string nyNumber = "s" + incNumber.ToString("00");
incNumber++;

edited Feb 04 '11 at 11:59

tenfour

36,141
15
83
142

answered Feb 04 '11 at 11:53

Øyvind Bråthen

59,338
27
124
151

2

I think you still need to increment the number though. ;) – Ray Booysen Feb 04 '11 at 11:54

Shekhar_Pro · Answer 2 · 2011-02-04T13:14:31.993

Do as suggested by Øyvind Knobloch-Bråthen but if you want it to be done automatically when form is Deactivated and Activated (You come back to the form and give it focus) then you can do somthing like this.

This only works if you are sure the text in box will always be in the mentioned format

this.Activated += (s, ev)=>{ 
         string tmp = textbox1.Text; 
         int num = String.Substring(1) as int;              
         if(nuum != null) 
         {
             num++;
             textbox1.Text = "s" + num.Tostring();  
         }
      };

score 2 · Answer 3 · answered Feb 04 '11 at 12:50

Just as Øyvind Knobloch-Bråthen said: Keep track of the integer using a variable. Only you should format it like this (Microsoft preferred):

int incNumber = 0;

string formattedIncNumber = String.Format("s{0:D2}", incNumber);
incNumber++;

Or if you want to do it with one line less code:

int incNumber = 0;

string formattedIncNumber = String.Format("s{0:D2}", incNumber++);

See MSDN for a complete reference for formatting integers.

score 2 · Answer 4 · answered Aug 30 '11 at 14:37

2

A slightly better variation of oyvind-knobloch-brathen's above:

int incNumber=0;
s + String.Format("{0:00}", incNumber);  
incNumber++;

//s00, s01, s02. If you want, say, the range 0001-9999, just change "00" to "0000", etc.

answered Aug 30 '11 at 14:37

Olatunji Owolabi

21
2

score 1 · Answer 5 · answered May 20 '15 at 15:08

If the text component of the string is unknown (with or without a number at the end of the string), variations of this function may be helpful:

        private string increment_number_at_end_of_string(string text_with_number_at_the_end)
        {
            string text_without_number = text_with_number_at_the_end.TrimEnd('0', '1', '2', '3', '4', '5', '6', '7', '8', '9');
            string just_the_number = text_with_number_at_the_end.Substring(text_without_number.Length);

            int number = -1;
            if (int.TryParse(just_the_number, out number))
            {
                return text_without_number + (number + 1).ToString();
            }
            return text_with_number_at_the_end;
        }

score 0 · Answer 6 · edited May 23 '12 at 15:31

0

Try This For auto generation of number and auto incrementation of number:

// Stock is table name
// metal id is unique number that is auto generated as well as auto incremented


private void textBox9_TextChanged(object sender, EventArgs e)
{
    string s = "select max(metalid)+1 from stock";
    SqlCommand csm = new SqlCommand(s, con);

    con.Open();
    csm.ExecuteNonQuery();

    SqlDataReader dd = csm.ExecuteReader();

    while (dd.Read())
    {
        int n = dd.GetInt32(0);
        textBox1.Text = n.ToString();
    }

     con.Close();
}

edited May 23 '12 at 15:31

Bob Kaufman

12,864
16
78
107

answered May 23 '12 at 13:40

Ritesh Desai

1

OP is not dealing with databases. – Victor Zakharov Oct 21 '12 at 01:01

score 0 · Answer 7 · answered Nov 13 '12 at 07:01

0

Another single line approach would be:

string sampleNum = "s" + (counter++).ToString("00");

Where counter defines like this:

int counter= 0;

answered Nov 13 '12 at 07:01

NeverHopeless

11,077
4
35
56

score 0 · Answer 8 · answered Aug 06 '18 at 08:56

This is the solution to generator auto incremented id in C# which don't need to increase or do anything. It will just work. whenever a new object created its value will increase by 1.

public class Employee
    {
        static long AutoId = 0;
        public long Id { get; private set; } = ++AutoId;
        public string EmployeeName { get; set; }
        public string Address { get; set; }
    }

score -2 · Answer 9 · answered Apr 29 '17 at 04:07

{  try {  //madhura//  SqlCommand cmd1 = new SqlCommand(@"select 'Column_name'+ REPLACE(STR(MAX(CAST(Right(Column_name,5) as int)+1 ),6),SPACE(1),'0') as Column_name from TabelName ", con);  SqlDataAdapter da = new SqlDataAdapter(cmd1);   DataTable dt = new DataTable();  da.Fill(dt);

if (dt.Rows[0][" Column_name'"].ToString() == null) { Label1.Text = "DMBP-000001"; } else{ Label.Text= dt.Rows[0][" Column_name'"].ToString(); } } catch { } }

What does it have to do with the question? – Alexander Leonov Apr 29 '17 at 04:12 — Alexander Leonov, Apr 29 '17 at 04:12

How can I automatically increment numbers in C#?

9 Answers9

Linked

Related