how can we generate auto id with .NET

Question

i would facing a problem while working in C#. AS i have to generate an ID which is automatically when user clicks on ADD button

Answer 1

If you can modify the schema, do what @John Saunders says. If you have to make your own identify for some reason, try using a GUID.

Guid g = Guid.NewGuid();

Answer 2

If I understand your question, you will be adding a row to a database table when the user clicks an ADD button, and you want the row to get an automatically-generated ID.

Simply add an IDENTITY column. You should probably make it the primary key, as well:

CREATE TABLE [dbo].[Table_1](
    [ID] [int] IDENTITY(1,1) NOT NULL,
    [MORE_DATA] [nvarchar](50) NULL
)