how to increment a text box field name(id) so that every user gets unique application id

Question

5.00/5 (1 vote)

See more:

hello, in my project(car rental system) ,in of the windows form application i want a unique receipt number generated when user completes the payment form.In cancellation form containing receipt no,emailand booked date when he fills receipt no ,his email_id and booked date should come automatically.i am having the user atble with all the fields like username,email...and booking table consists of booked date.plz help me...

Posted 30-Sep-11 20:15pm

satishmachineni

Add a Solution

4 solutions

Add a Solution

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

BobJanova · Accepted Answer · 2011-10-03T03:46:00

In a database, set the id field to auto_increment for a unique, consecutive sequence. Generate GUIDs for random looking (i.e. unguessable) IDs – but GUIDs typically don't index as well as ints so I recommend having an auto_increment internal ID as the primary key even if you decide you want to be more opaque with what you display to the user.

A booking should be tied to a user and then the query you want is something like:
select booking.receiptno, booking.bookingdate, user.email from booking left join user on booking.user = user.username where booking.receiptno = @receiptno

Mehdi Gholam · Accepted Answer · 2011-09-30T20:22:00

Solution 1

Use Guid.NewGuid() it will give you a unique identifier.

Posted 30-Sep-11 20:22pm

Mehdi Gholam

Herman<T>.Instance · Accepted Answer · 2011-09-30T20:24:00

Solution 2

create a GUID(). That is a unique key generate in .net.

Posted 30-Sep-11 20:24pm

Herman<T>.Instance

Koushik Uppari · Accepted Answer · 2011-10-03T03:33:00

public StudentDetails()
{
InitializeComponent();
BindEmpId();//caling the method here
}
private void BindEmpId()
{
con.Open();
cmd = new SqlCommand("select Roll_No from StudentDetails", con);
cmd.CommandType = CommandType.Text;
dr = cmd.ExecuteReader();
while (dr.Read())
{
temp = int.Parse(dr.GetValue(0).ToString());
}
txtRollNumber.Text = (temp + 1).ToString();
con.Close();
}

how to increment a text box field name(id) so that every user gets unique application id

4 solutions

Solution 4

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

how to increment a text box field name(id) so that every user gets unique application id

4 solutions

Solution 4

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us