how to get unique id auto

Question

3.00/5 (1 vote)

See more:

hi!

i have a from in which i have two text boxes
texboxid
texboxname
i want to get auto number in textboxid whenever i want to enter new entry
using sql server 2008
how it will be done

Posted 21-Jul-11 1:10am

kami124

Add a Solution

5 solutions

Solution 2

Don't have an ID entered in the form. Generate it automatically in the table by having the field for ID set up as integer column and as Identity with increment 1 in Column properties in sql2008

Posted 21-Jul-11 1:16am

Herman<T>.Instance

Updated 21-Jul-11 1:19am

v3

Solution 1

hi,
pick the last entry from the table and incriment the the count by on eand set it as id.auto incrimen tthe id field
regards,
shefeek

Posted 21-Jul-11 1:13am

shefeekcm

Updated 21-Jul-11 1:20am

v2

Comments

Philippe Mori 21-Jul-11 7:23am

You never knows if someone else add a row in the mean time (particulary on the web). For a new record, you should never display an ID but let SQL pick one when the row is inserted. For existing records, it is generally not that much useful for the end user to see it.

shefeekcm 21-Jul-11 7:30am

thnks for your information.i know that its only to give an answer to the questioner.

Solution 3

hey! you can use NEWID function. with assigning it will enable you to generate the default value of NEWID(), each new and existing row has a unique value for the associate Column.
Take a look fore more details
NEWID (Transact-SQL)[^]

Posted 21-Jul-11 1:27am

RaviRanjanKr

Solution 5

Putting the ID into a textbox is ludicrous. Just configure the table's ID column to be auto-incrementing, and the database will fill it in for you when you add a new row of data.

Posted 21-Jul-11 1:37am

#realJSOP

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 From Patna · Accepted Answer · 2011-07-21T01:27:00

you try this code which retrieve the last row form your table

private int NewId(){
SqlConnection con = new SqlConnection(//your ConnectionStrings);
        SqlDataAdapter adapter = new SqlDataAdapter("Select * from yourtablename", con);
        SqlCommandBuilder cmd = new SqlCommandBuilder(adapter);
        DataSet ds = new DataSet();
        adapter.Fill(ds);
        int ID = 0;
        if (ds.Tables[0].Rows.Count > 0)
        {
            int len = ds.Tables[0].Rows.Count - 1;
            ID = int.Parse(ds.Tables["Arcticle"].Rows[len]["arcId"].ToString()) + 1;
        }
        else
            ID = 1;

return ID;
}

you call above function where you need to new id.