Ad:

C# Discussion Thread
Unsolved
Views: 11020

Jan 19th, 2008

Auto generation of numbers..

Expand Post »

Hi all webbers,
I have a problem of generating numbers automatically....
Actually i have a textbox and the textbox should autogenerate a number everytime the page loads or whenever the user clicks the next button after filling in the values.....

Help me out dudes.......Sample code would help me a lot.....

Last edited by bharathi_n_r; Jan 19th, 2008 at 2:35 am.

Similar Threads

Putting Auto Numbers in a File in C#

bharathi_n_r

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

25 posts
since Jan 2008

Permalink

Jan 19th, 2008

Re: Auto generation of numbers..

Can you describe the number? Something completely (pseudo)random? A unique ID? A sequence number? What you're using it for determines how you generate it.

Narue

Administrator

Reputation Points: 6442

Solved Threads: 1393

Bad Cop

Offline

11,807 posts
since Sep 2004

Permalink

Jan 21st, 2008

Re: Auto generation of numbers..

I am using the numbers for serializing my datas..The numbers should generate automatically like 1 for the first record 2 for the second 3, 4 ,5 etc...But the number should continue even he logs out and logs in next time.The form contains Issue number, Name,Address,Issue Date etc...I want the issue number to get generated automatically.....I hope it clears ur question...!

bharathi_n_r

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

25 posts
since Jan 2008

Permalink

Jan 21st, 2008

Re: Auto generation of numbers..

Dude,
I managed to generate the numbers,but i have a little problem.I have given this code in my page load event to fetch the last record from the database and increment the value of issue_no by one.It is incrementing the value but once i click the add button after filling other details,the next number is not getting incremented after the button click,any suggestion man....It is getting incremented after i sttoped and then running my program again....
I want the next no to be incremented so that the user can enter multiple datas without closing the application....

C# Syntax (Toggle Plain Text)
Con = new SqlConnection("Data Source=PSTLCORPSERV;Initial Catalog=Error;Persist Security Info=True;User ID=sa;Password=sqlserver12#");
            Con.Open();
            Cmd = new SqlCommand("select issue_no from error", Con);
            Data = Cmd.ExecuteReader();
            while (Data.Read() != false)
            {
 
                auto = Data.GetString(0);	
 
            }
            try
            {
 
                int newid = Int32.Parse(auto);
                int id = newid + 1;
                this.textBox1.Text = id.ToString() + "";
 
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message + ex.Source);
            }
 
            Data.Close();
Con = new SqlConnection("Data Source=PSTLCORPSERV;Initial Catalog=Error;Persist Security Info=True;User ID=sa;Password=sqlserver12#");
            Con.Open();
            Cmd = new SqlCommand("select issue_no from error", Con);
            Data = Cmd.ExecuteReader();
            while (Data.Read() != false)
            {

                auto = Data.GetString(0);	

            }
            try
            {

                int newid = Int32.Parse(auto);
                int id = newid + 1;
                this.textBox1.Text = id.ToString() + "";

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message + ex.Source);
            }

            Data.Close();

Last edited by bharathi_n_r; Jan 21st, 2008 at 2:47 am.

bharathi_n_r

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

25 posts
since Jan 2008

Permalink

Jan 22nd, 2008

Re: Auto generation of numbers..

your code is true but did a little more.
make the procedure or function to generate auto number only. so you can call this procedure or function after you add,edit,delete or clear form.

Last edited by Jx_Man; Jan 22nd, 2008 at 3:47 pm.

Jx_Man

Reputation Points: 1182

Solved Threads: 392

Posting Sensei

Offline

3,138 posts
since Nov 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in C# Forum Timeline: Running my application outside the enviroment

Next Thread in C# Forum Timeline: question in C#

DaniWeb Message

Cancel Changes

User Name
Password