How to change Number in asp.net Textbox on save button click?

Question

5.00/5 (1 vote)

See more:

.NET3.5

i have a form that is having 3textbox's just i want to save data for eg: in textbox1.text=001(this is automatic change to 002)after saving data into database i don't want to enter any thing, on page it should be start with 001,second time 002,third time 003 like

Posted 30-Jul-10 2:40am

chandrasekhar_b

Add a Solution

2 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)

Ankur^\m/ · Answer 1 · 2010-07-30T03:47:00

You can do this by declaring a class level static variable. Increment and display it in the button click event.

But I don't think it will solve the purpose. That's because if another user opens up the same page, he will also see the incremented count.

Few options to achieve this:
Use Session to store the count: Session is user specific and so there will be different session created for different user.
ViewState: You can also store the count in ViewState variable.
Cookies: May store it on the client's using cookies.

Session and ViewState are heavy objects and so I would not recommend it's use for this scenario. The best option would be:

Use a hidden field and store the value in it. On button click, get the value, increment, display and save it to the same hidden field.

Hope it answers your question. Let me know if you have any doubt. (Use Add Comment to reply).

Yusuf · Answer 2 · 2010-07-30T03:02:00

Solution 1

If you are saving the data to database, why not save your counter in the database as well? Then you can format however you like in the UI. It is not hard to format your number as 001, 002,....

Posted 30-Jul-10 3:02am

Yusuf

Comments

Ankur^\m/ 31-Jul-10 0:21am

If you save it in database, how will the counter different for every user? I think you misunderstood the question. :)

Yusuf 31-Jul-10 0:53am

Well, I don't think he said - different for every user. Did he? The requirement as stated is it starts with 001 and it gets incremented when the data is saved. There is no user involved.

Ankur^\m/ 31-Jul-10 1:19am

But he did say, it's an ASP.NET application which made me assume that each user will have their own count.
Anyway I never meant you are wrong in your answer, I just said you probably got the question wrong.
Quite possible I may have got the question wrong as well. But since the OP has left no comment, I will assume we both are right. :)
Cheers!