Auto Incremented userdefined id

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

Hi can anyone give me an idea how to create an auto generated id like ED01,ED02 etc., so that when i am entering data the id should be automatically incremented

Posted 29-Aug-10 22:17pm

anupama962010

Add a Solution

3 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)

demouser743 · Answer 1 · 2010-08-29T22:26:00

Solution 1

private static int EmpId = "ED00";

Form load

MIDL

visitCounter++;

   textBox1.Text = visitCounter;

This will automatically increment the vale but if you close the application again it will take from starting.

Posted 29-Aug-10 22:26pm

demouser743

Updated 29-Aug-10 22:29pm

v2

Comments

anupama962010 30-Aug-10 4:28am

i am a starter to be specific for sql server can u give me a more details about the answer you have give. thanks in advance

demouser743 30-Aug-10 4:30am

from the code you can pass in that way.

demouser743 30-Aug-10 4:34am

Can you please tell whether you want to auto increment the id itself in sql or you would like to display the auto generate id in your textbox and will pass to sql

anupama962010 30-Aug-10 6:44am

i have textboxes which consists of id and name where, in id i need to display the auto generated code which is user defind(Ex01) and next to the last value in the database automatically and enter the name. then i have to save both in database.
example if i have ED05 record as last record in database then in the id textbox it should show ED06 & this field is not writable. then name is entered and both are stored in database so whenever when the next user sees the text box it should check database and then display ED07

demouser743 · Answer 2 · 2010-08-29T23:04:00

Solution 2

SQL

create  TABLE ED(
  ID INTEGER PRIMARY KEY IDENTITY(1, 1)
  , UserID AS 'ED' + CAST(ID AS VARCHAR(32))
  , I INTEGER
)


DECLARE @I INTEGER
SET @I = 0
WHILE @I < 100
BEGIN
  SET @I = @I + 1
  INSERT INTO ED VALUES (@I)
END

Try this as per your requirement

Posted 29-Aug-10 23:04pm

demouser743

demouser743 · Answer 3 · 2010-08-29T23:08:00

Solution 3

SQL

CREATE



TABLE user(id INT NOT NULL IDENTITY(1,1),

col

AS 'ED'+

RIGHT(




'0'+CAST(id AS VARCHAR(2)),2))

INSERT



INTO userDEFAULT VALUES

SELECT




* FROM user

Posted 29-Aug-10 23:08pm

demouser743