Auto generate transaction id with prefix in c#

Question

3.00/5 (2 votes)

See more:

Hello...

i work on one asp.net project in that i need one auto generate transaction id with prefix.it should be like vehicle identification number. which should be common id.
for that what should i do ?

Posted 24-Jul-13 18:57pm

Archit Patel

Updated 24-Jul-13 19:05pm

v2

Add a Solution

Comments

Jignesh Khant 25-Jul-13 1:20am

While making the table of your vehicle table in database(SQL), create a column id and make it autogenerate. This will serve your purpose.

[no name] 25-Jul-13 1:22am

no it not work i want all transaction id length with 10 or 12 char.

V.Lorz 17-Sep-13 7:18am

Most databases support using 32 bit unsigned integers for the row id column value, that gives you around 4294967296 values, which is in the the range of 10-to-12 characters wide when represented in text format. Zero padding-left will complete your text length.

Jignesh Khant 25-Jul-13 1:30am

Then you can assign a random number to each vehicle as its vehicle id when you insert it for first time.

[no name] 25-Jul-13 1:34am

yes that want you are right but how can i do it ? and also it number must be uniq

6 solutions

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)

Rakesh Meel · Answer 1 · 2013-09-16T21:33:00

Solution 6

you can visit here....

http://www.dotnetspider.com/resources/44431-How-add-prefix-auto-generated-ID-based-some-conditions.aspx[^]

Posted 16-Sep-13 21:33pm

Rakesh Meel

Jignesh Khant · Answer 2 · 2013-07-24T19:46:00

Solution 2

Try this code:

C#

System.Random rand = new System.Random((int)System.DateTime.Now.Ticks);
        int random = rand.Next(1, 100000000);

Here variable 'random' will be your unique random number.

Posted 24-Jul-13 19:46pm

Jignesh Khant

Updated 16-Sep-13 22:29pm

v2

Comments

[no name] 25-Jul-13 1:57am

it's good but how can you sure that the number is unique ?

Jignesh Khant 25-Jul-13 2:01am

int random = rand.Next(1, 100000000);

see this line, it means it will generate nos between the range 1-100000000 without repetition. You can always change this range according to your needs.

[no name] 25-Jul-13 2:06am

yes but one time it generate '23450' number when i test it how can it possible ?

Jignesh Khant 25-Jul-13 2:09am

I am not getting you.

V.Lorz 17-Sep-13 7:04am

Random number generators are what their name says, Random, and that means it has inherent unpredictability. Random generators tend to follow some kind of 'distribution', it can be gaussian, normal, etc.

You may absolutely be sure that numbers in a random series will appear more than once with higher or lower probability denpending on the distribution function of the generator whether it be hardware (true generator) or software (pseudo generator).

Chui PuiKwan · Answer 3 · 2013-07-24T20:06:00

Solution 3

C#

public string generateID()
{
    return Guid.NewGuid().ToString("N");
}

http://msdn.microsoft.com/zh-cn/library/system.guid.newguid.aspx[^]

<pre>Guid: Represents a globally unique identifier (GUID).</pre>

Posted 24-Jul-13 20:06pm

Chui PuiKwan

Comments

V.Lorz 17-Sep-13 7:11am

Note that he wants to keep the id in the 10 to 12 chars range.

Zafar A khan · Answer 4 · 2013-07-24T19:25:00

concatenate vehicle identification No with Max Transaction ID Like the following.
in the code VID2345 is vehicle ID

C#

SqlConnection con=new SqlConnection("Data Source=(local); Initial Catalog=salepur; Integrated Security=SSPI");
SqlCommand com=new SqlCommand(@"SELECT isnull(Max(cast(substring(tranID,charindex('-',tranID)+1,len(tranID)) as int)),0)+1
  FROM  [tbltran]",con);
con.Open();
int tranID=int.Parse(com.ExecuteScalar().ToString());
con.Close();
string TransactionID="VID2345"+"-"+tranID;

Jhone2011 · Answer 5 · 2013-07-24T20:53:00

Solution 4

you can use below trick

C#

DateTime.Now.ToString("ddmmyyhhmmss");

but i will suggest you to create one unique identity column in your table and concate that id with any prefix and use it

Posted 24-Jul-13 20:53pm

Jhone2011

Updated 16-Sep-13 22:30pm

v2

Comments

V.Lorz 17-Sep-13 7:08am

This is not appropiate for generating unique ids. If you have a fast computer you'll be able to generate the same id thousands or even millions of times during the time lapse of one second.

Furthermore, when Windows updates the internal RTC (real time clock) for synchronizing with time services you may run again in the same problem, your local RTC could have been running faster than the reference clock used by the time server.

Member 10239720 · Answer 6 · 2013-09-16T21:10:00

C#

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using System.Data.Sql;
using System.Data;
using System.Configuration;

public partial class Reg : System.Web.UI.Page
{
    string strConn = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
    string str;
    SqlCommand com;
    int count;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            autogenerated();
        }
    }
    void autogenerated()
     { 
        SqlConnection con= new SqlConnection(strConn);
        str= "select count (*) from Reg";
        com = new SqlCommand(str,con);
        con.Open();
        count = Convert.ToInt16(com.ExecuteScalar())+1;
        TextBox EmpId.Text = count.ToString();
        TextBox EmpId.Enabled= false;
        con.Close();
    }
    
    protected void Button1_Click(object sender, EventArgs e)
    {
      
        SqlConnection con = new SqlConnection(@"Data Source=VIJAY-PC\SQLEXPRESS;Initial catalog=Reg;Integrated Security=True");
        con.Open();
        string q = "Insert into Reg (EMPID,[EMP Name],[Account Holder],[Account Number],[Account IFSC Number],[Emp Email],[Emp Password],[Confrim Password],[Emp Photo])Values('" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + TextBox4.Text + "','" + TextBox5.Text + "','" + TextBox6.Text + "','" + TextBox7.Text + "','" + TextBox8.Text + "','" + TextBox9.Text + "')";
        SqlCommand com = new SqlCommand(q, con);
        com.ExecuteNonQuery();
        con.Close();
        autogenerated();
        }   
    }

Auto generate transaction id with prefix in c#

6 solutions

Solution 6

Solution 2

Solution 3

Solution 1

Solution 4

Solution 5

Add your solution here

Preview 0