Can I count text values using static variables in vb 2005 or vb 2008?

Question

0.00/5 (No votes)

See more:

Can I count using static variables in vb 2005 or vb 2008? As an example There is a value that entered previously as a Supplier no = SUP0010. I want to get the next Supplier no as 'SUP0011' by automatically counting the existing last entered Supplier No.

Posted 22-Oct-11 6:25am

Chiranthaka Sampath

Add a Solution

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)

Abhinav S · Accepted Answer · 2011-10-22T06:33:00

Solution 1

Yes you can do this using a static or a class level instance variable.
Just set this variable to 0 initially. Then use substring to get the last four characters of the current supplier no. Convert this into an integer and increment and store it in the variable.

You can then use the variable to get the next supplier no by appending SUP to the number and padding the integer by using the PadLeft function[^].

Posted 22-Oct-11 6:33am

Abhinav S

Comments

Chiranthaka Sampath 22-Oct-11 12:45pm

What is this sub-string is it like to be like the concatenation in vb?

Abhinav S 23-Oct-11 0:47am

Substring is like the Mid command in VB.

Chiranthaka Sampath 22-Oct-11 12:48pm

If I used a Mask text Box instead of how can I do that? This mask text box include the 'SUP' characters as its text proper tie's value!

Abhinav S 23-Oct-11 0:48am

You can do something similar in the masked control - take out the last 4 values and use them as the key.