how to create autonumber

Question

1.00/5 (5 votes)

See more:

C#2.0

C#

How to create autonumber function for a database using c#. Provide the clear code only in c#

Posted 25-Jun-12 20:06pm

P.Vinoth

Add a Solution

1 solution

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)

OriginalGriff · Accepted Answer · 2012-06-25T20:20:00

Solution 1

All you have to do is connect to your DB in the usual way, and create an SqlCommand such as:

USE [MyDataBaseName]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MyTable](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nchar](10) NOT NULL,
) ON [PRIMARY]
GO

Then call ExecuteNonQuery.

P.S. If you had been a little polite, you might have got a better solution.
We do not work for you, we do not get paid to do this, and rude arrogance like you show will not get you far.

Posted 25-Jun-12 20:20pm

OriginalGriff

Comments

Sebastian T Xavier 26-Jun-12 2:50am

my +5

P.Vinoth 26-Jun-12 4:05am

i need that to be created in c#. I already Created an client_info database i need to assign client_id as autonumber through c# coding. If i insert a record its keep on increasing

P.Vinoth 26-Jun-12 4:58am

i didn't asked you to post the answer quickly if you know the answer post it otherwise stay away . you always post the irrelevant answers. i didn't compel you to post the answer . Use the words correctly

OriginalGriff 26-Jun-12 5:05am

Oh, I know the answer.
But your attitude does not encourage me to spend my time helping you in this case.
Perhaps you should rethink how you approach people when you want help from them?
Just a thought.

P.Vinoth 26-Jun-12 5:30am

whats wrong in my approach. oh you want me to beg you for the answer.

OriginalGriff 26-Jun-12 5:36am

No, but it is rude to give orders. Your question is not a question, but a vague question with a command added.
Would you appreciate it if you were told what to do, by someone who doesn't pay your wages?
Now read it again, and your responses so far.

P.Vinoth 26-Jun-12 5:32am

you posted the irrelevant answer so i explained it. whats wrong in it? Just think

P.Vinoth 26-Jun-12 5:42am

you posted the comment first(rude ,arrogance and all). oh, if you are acting smart means you are not a good person. if somebody asks help means try to help don't act like this. if you provide the answer means you are not god ok. You first read what you have posted. first correct your mistakes then you will correct others.