Generating Unique ID manually through code.

Question

0.00/5 (No votes)

See more:

Hi,

Can you please send me the code for generating the Unique ID manually through code which is combination of prefixed string which is constant and postfixed by number which is increasing at each time of registration.

For Example,
I want to generate the Id through code. Whose output should be as follows,

org001
org002
org003 etc...

Thanks in advance.

Posted 28-May-12 22:50pm

rp786

Add a Solution

4 solutions

Solution 1

The code for that is trivial: just increment a counter and properly format a string with the fixed prefix and the current value of the counter, e.g.

C#

string newID(string prefix)
{
  counter++;
  return prefix + counter.ToString("D3");
}

However counter needs to be persistent, that is you have to save it to a file if you need to maintain uniqueness on application restarts.

Posted 28-May-12 23:04pm

CPallini

Comments

Prasad_Kulkarni 29-May-12 5:13am

Good one 5!

CPallini 29-May-12 5:25am

Thank you.

Solution 2

C#

SqlConnection cnn = new SqlConnection(your connection String);
    SqlCommand cmd;
    static string path;

    protected void Page_Load(object sender, EventArgs e)
    {

     
        cnn.Open();
       
        string str = "Select count(*) from  tablename";
        cmd = new SqlCommand(str, cnn);
        object necd;
        int newecd;
        cmd = new SqlCommand(str, cnn);
        necd = cmd.ExecuteScalar();
        newecd = Convert.ToInt16(necd) + 1;
        string necode;
        necode = "org00"  + newecd.ToString();
        txtccode.Text = necode.ToString();
        cnn.Close();
    }

may this code help you.....

Posted 28-May-12 23:08pm

aarohi verma

Updated 28-May-12 23:12pm

v3

Comments

Prasad_Kulkarni 29-May-12 5:13am

My 5!

Solution 4

You need to concatinate the two strings
1. Get the constant string eg. ABC
2. Retrive the total count value from the database (eg. count = 5)
If you are using the SQL server as your database.
You can also use file to store the data.
Now add two string
suppose string str = ABC
and int value = count + 1;
now,

C#

string id = str + value.ToString();

Remember, you can only concatinate strings.

Posted 28-May-12 23:39pm

Santoshshrest

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

vangapally Naveen Kumar · Accepted Answer · 2012-05-28T23:20:00

try like this

C#

con = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString);
     da = new SqlDataAdapter("select id from sample order by id desc", con);
      ds = new DataSet ();
      da.Fill(ds);


      string orgname = "AAA";
      if (ds.Tables[0].Rows.Count > 0)
      {
          i = Convert.ToInt32(ds.Tables[0].Rows[0][0].ToString());
          i = i + 1;
      }
      else { i = 1; }
      string empname = orgname + Convert.ToString(i);

     if(con.State ==ConnectionState.Closed )
         con.Open ();
     cmd = new SqlCommand("insert into sample(id,name,address) values('" + empname + "','" + txtname.Text + "','" + txtaddr.Text + "')", con);
     int j = cmd.ExecuteNonQuery();
     con.Close();

Generating Unique ID manually through code.

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0

Generating Unique ID manually through code.

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us