Click here to Skip to main content
15,926,382 members
Home / Discussions / C#
   

C#

 
AnswerRe: 2 Questions Pin
Rudolf Jan28-Mar-07 0:10
Rudolf Jan28-Mar-07 0:10 
GeneralRe: 2 Questions Pin
JMOdom28-Mar-07 13:27
JMOdom28-Mar-07 13:27 
QuestionSystem.Diagnostics.Process.StartInfo Username= "default user"? Pin
Austin Harris27-Mar-07 6:59
Austin Harris27-Mar-07 6:59 
AnswerRe: System.Diagnostics.Process.StartInfo Username= "default user"? Pin
kubben27-Mar-07 7:57
kubben27-Mar-07 7:57 
GeneralRe: System.Diagnostics.Process.StartInfo Username= "default user"? Pin
Austin Harris27-Mar-07 8:48
Austin Harris27-Mar-07 8:48 
GeneralRe: System.Diagnostics.Process.StartInfo Username= "default user"? Pin
kubben27-Mar-07 9:19
kubben27-Mar-07 9:19 
QuestionAuto generated number Pin
Neo_Shehpar27-Mar-07 6:44
Neo_Shehpar27-Mar-07 6:44 
AnswerRe: Auto generated number Pin
Leslie Sanford27-Mar-07 7:23
Leslie Sanford27-Mar-07 7:23 
I don't know if I can offer help here as I'm not familiar with "T-SQL." Do you just need an algorithm for generating the numbers?

Off the top of my head, one way to do it would be to have an integer representing the first part of the number, the 0000 part. Also have three characters, each representing one of the letters in the letter part of the number. Initialize the number to 0 and each character to 'A', and do something like this:

using System;
using System.Collections.Generic;
using System.Text;
 
namespace AutoNumber
{
    class Program
    {
        static int number = 0;
        static char[] characters = { 'A', 'A', 'A' };
 
        static void Main(string[] args)
        {
            for(int i = 0; i < 10000; i++)
            {
                Console.WriteLine(GenerateNumber());
            }
 
            Console.Read();
        }
 
        static string GenerateNumber()
        {
            number++;
 
            if(number > 9999)
            {
                number = 0;
 
                for(int i = characters.Length - 1; i >= 0; i--)
                {
                    if(characters[i] == 'Z')
                    {
                        characters[i] = 'A';
                    }
                    else
                    {
                        characters[i]++;
 
                        break;
                    }
                }
            }
 
            return new string(characters) + "-" + number.ToString();
        }
    }
}


The algorithm rolls over after you reach ZZZ-9999.
GeneralRe: Auto generated number Pin
Christian Graus27-Mar-07 7:26
protectorChristian Graus27-Mar-07 7:26 
AnswerRe: Auto generated number Pin
Christian Graus27-Mar-07 7:24
protectorChristian Graus27-Mar-07 7:24 
AnswerRe: Auto generated number Pin
Austin Harris27-Mar-07 7:27
Austin Harris27-Mar-07 7:27 
AnswerRe: Auto generated number Pin
kubben27-Mar-07 7:42
kubben27-Mar-07 7:42 
GeneralRe: Auto generated number Pin
Austin Harris27-Mar-07 8:52
Austin Harris27-Mar-07 8:52 
GeneralRe: Auto generated number Pin
kubben27-Mar-07 9:13
kubben27-Mar-07 9:13 
AnswerRe: Auto generated number Pin
Neo_Shehpar29-Mar-07 11:02
Neo_Shehpar29-Mar-07 11:02 
Questionhow to get logged in user name Pin
Nkuttynasi27-Mar-07 6:40
Nkuttynasi27-Mar-07 6:40 
AnswerRe: how to get logged in user name Pin
Not Active27-Mar-07 6:46
mentorNot Active27-Mar-07 6:46 
QuestionTranspose - Converting columns to rows Pin
BanarasiBhaiya27-Mar-07 6:33
BanarasiBhaiya27-Mar-07 6:33 
QuestionQuickly need a listing of classes/methods/signatures - how? Pin
sherifffruitfly27-Mar-07 6:21
sherifffruitfly27-Mar-07 6:21 
AnswerRe: Quickly need a listing of classes/methods/signatures - how? Pin
Christian Graus27-Mar-07 6:30
protectorChristian Graus27-Mar-07 6:30 
AnswerRe: Quickly need a listing of classes/methods/signatures - how? Pin
Not Active27-Mar-07 6:30
mentorNot Active27-Mar-07 6:30 
GeneralRe: Quickly need a listing of classes/methods/signatures - how? Pin
sherifffruitfly27-Mar-07 6:53
sherifffruitfly27-Mar-07 6:53 
QuestionCan you compile in C# i.e. cntrl F7 Pin
LCI27-Mar-07 6:03
LCI27-Mar-07 6:03 
AnswerRe: Can you compile in C# i.e. cntrl F7 Pin
Not Active27-Mar-07 6:12
mentorNot Active27-Mar-07 6:12 
AnswerRe: Can you compile in C# i.e. cntrl F7 Pin
Christian Graus27-Mar-07 6:12
protectorChristian Graus27-Mar-07 6:12 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.