Auto Increment Of Alphanumeric number using c#

Question

Hi Can you explain me how to auto increment the value like C00001C00002 ..............C00010C0011.. using c#.net with asp.net webapplication and connection with sql server thank you regards NagaRaju

Iftikar Hussain · Answer

try like this private void AutoIncrement() { var str = Label1.Text; var tempArray = str.Split('/'); string tempId = tempArray[2]; int id = Convert.ToInt32(tempId); id = id + 1; string autoId =QIEpl/PO/ + String.Format({0:0000000} id); Label1.Text = autoId; } Regards Iftikar

Pavan Sai · Answer

http://www.c-sharpcorner.com/blogs/alphanumeric-string-increment-in-c-sharp1 Go through the above link...it will hep you out

sujit singh · Answer

Can you explain me how to auto increment the value like A001A002 ..............A010A011.. A099... A111 using c#.net with windows application and connection with sql server

sujit singh · Answer

Can you explain me how to auto increment the value like A001A002 ..............A010A011.. A099... A111 using c#.net with windows application and connection with sql server

Pavan Sai · Answer

http://www.c-sharpcorner.com/blogs/alphanumeric-string-increment-in-c-sharp1 Go through the above link...it will hep you out

Rakesh M B · Answer

string p = c0000; for (int i = 1; i { string p1 = p + i; string i2 = i.ToString(); int h = i2.Length; int u = p.Length - h; string y = p1.Substring(0 u); p1 = y + i; Response.Write(p1 +  ); }

Nayaneesh Kumar · Answer

User/00001 wih auto increament c# code

NAGARAJU TAMADA · Answer

Thank u For giving Reply to me Sir.Its Working fine now. My OrderNo Increased Like my formate

Vulpes · Answer

Here's a more general version of my own method which now allows for any number of non-digits (previously just one) followed by any number of digits: static string IncrementID(string startValue int numNonDigits) { string nonDigits = startValue.Substring(0 numNonDigits); int len = startValue.Length - numNonDigits; int number = int.Parse(startValue.Substring(numNonDigits)); number++; if (number >= Math.Pow(10 len)) number = 1; // start again at 1 return String.Format({0}{1:D + len.ToString() + } nonDigits number); } For example: Label1.Text = = IncrementID(QIEpl/PO/0000009 9); // produces QIEpl/PO/0000010

Vulpes · Answer

The C# code to increment something like C00010 would be: static string IncrementID(string startValue) { char letter = startValue[0]; int len = startValue.Length - 1; int number = int.Parse(startValue.Substring(1)); number++; if (number >= Math.Pow(10 len)) number = 1; // start again at 1 return String.Format({0}{1:D + len.ToString() + } letter number); } You can call as follows: Label1.Text = IncrementID(C00010); // C00011

NAGARAJU TAMADA · Answer

Sorry Sir I need The C# code but not Sql query.Here i add some details of form to Alphanumeric number . I have also This type of queries but not working. please reply to me

Iftikar Hussain · Answer

you can use like this in your sql query declare @Count int declare @id varchar(10) SET @Count = 1 WHILE (@Count BEGIN set @id='C'+RIGHT(REPLICATE('0' 4) + CAST(@Count AS VARCHAR(4)) 4) PRINT @id SET @Count = @Count + 1 END Regards Iftikar

NAGARAJU TAMADA · Answer

Thanks For Reply Sir my Alphanumeric number Starts from QIEpl/PO/0000001.There is no limit sir

Iftikar Hussain · Answer

is there any limitation or fixed range. Regards Iftikar

NAGARAJU TAMADA · Answer

Hi Sir i Had a Form With a TextBox.When I Load The Form The textbox will be fill with Alphanumeric number (like C0001C0002........ C0010 Not like C0001C0002.... C00010 ) From SqlServer

Iftikar Hussain · Answer

can you share your code where you want to show auto increment number in your form? Regards Iftikar

NAGARAJU TAMADA · Answer

I want to Load Alphanumeric Number while C# Window Form Loading From Database Please Reply to me

Iftikar Hussain · Answer

Hi You want to do auto increment while inserting data in sql? Regards Iftikar

Sanjeeb Lenka · Answer

check these link: http://beta.c-sharpcorner.com/Forums/Thread/163919/hi-how-to-auto-increment-for-text-and-char-in-sql-table.aspx http://www.c-sharpcorner.com/Forums/Thread/217528/ http://www.sqlteam.com/article/custom-auto-generated-sequences-with-sql-server