auto increment alpha numeric values using C sharp

Question

1.00/5 (1 vote)

See more:

Can you explain me how to auto increment the value like LG/SALES/1000,LG/SALES/1001, LG/SALES/1002.............LG/SALES/1030

i Had a Form With a label When I Load The Form The label will be fill with Alphanumeric number, THEN it will be stored into sq.

2.after that when i load the form max value comes from database and it will be incremented

my table name is sales and column name is sales_invoice(auto incremented values).

Posted 9-Aug-14 0:30am

Being The Sharan Kumar

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 · Answer 1 · 2014-08-09T00:33:00

Solution 1

Split on the / character using string.split[^].
Take the last value i.e. the number and the increment it by 1.

Posted 9-Aug-14 0:33am

Abhinav S

Comments

Being The Sharan Kumar 9-Aug-14 6:59am

@Abhinav sir i had tried this code. The problem is that the final result doesn't appear in lable18

private void AutoIncrement()
{
var str = label18.Text;
var tempArray = str.Split('/');
string tempId = tempArray[2];
int id = Convert.ToInt32(tempId);
id = id + 1;
string autoId = "LG/SALES/" + String.Format("{0:0000000}", id);
label18.Text = autoId;