AutoGenerate Id ( Insert data into database)

Question

0.00/5 (No votes)

See more:

I am using 3 Tier Architecture for insert the data into the database..
but my problem how to generate prod_id automatic without entering into textbox or label.
when page loads,it automatic change..
plz reply

Posted 21-Sep-12 21:07pm

mohit jain

Add a Solution

Comments

Manash Sahoo 22-Sep-12 3:38am

in which db u working on....if it is sql server then make ur prod_id identity,if u using mysql then make it autoincrement.....

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

Sandip.Nascar · Answer 1 · 2012-09-21T22:21:00

I am not sure which database you are working on but all rdbms database has colum - Audo feature.

Like in Sql server, you can use int and set identity to true
Even you can declare the datatype as uniqueidentifier and while you insert use NewId() to generate unique identifier.

In the sql or stored procedure return the maxid() value to get the id ir use @@Identity for Auto.

If you want to do it manually, get the last id using max() function and increment the number by one and send it to database. But check the concurrent issue.

Hope this helps.

cheers

Asim8748 · Answer 2 · 2012-09-21T22:04:00

Solution 1

Create a store procedure and use this code to insert .it insert prod_id automatically

<pre lang="SQL">

create procedure sp_insert_products
declare @prod_id nvarchar

as

set @prod_id = ( select isnull( (max(cast( prod_id as int ))),0) + 1 from products )
begin
insert into tbl_products
values (your values goes here)
end

Posted 21-Sep-12 22:04pm

Asim8748

Comments

mohit jain 24-Sep-12 1:24am

ALTER PROCEDURE AddRecords
(

@prod_id int,
@prod_title varchar(50),
@prod_qty varchar(50),
@prod_price varchar(50),
@prod_desc varchar(50),
@prod_imgpath varchar(50)

)

AS

insert into Products

(prod_id,prod_title,prod_qty,prod_price,prod_desc,prod_imgpath)

values

(@prod_id,@prod_title,@prod_qty,@prod_price,@prod_desc,@prod_imgpath)

RETURN