how to increment value and insert that value to database

Question

0.00/5 (No votes)

See more:

Query as follows

i have one table as follows control_file

ctrl_type   ctrl_last_no
 PKGNO         52

I have another table as follows Co_Package_Master

cpm_pkg_id   pkg_name
 PKG00000     EFA+PSSR

First Query as follows

SQL

Update control_file set ctrl_last_no = ctrl_last_no + 1 where ctrl_type = 'PKGNO'

Second Query as follows

SQL

select * from CONTROL_FILE where ctrl_type = 'PKGNO'

i get the ctrl_last_nor from control file table and increment one
i have Co_package_master table in that i want to insert the cpm_pkg_id as follows
PKG0000053

The above 53 value has get from control file and increment one value and want to be store in the co_package_master table.

for that how can i do in asp.net using c#.

Posted 13-Sep-15 19:01pm

sudhakarthikeyan

Updated 14-Sep-15 9:01am

Maciej Los

v2

Add a Solution

Comments

PIEBALDconsult 14-Sep-15 1:14am

Which database system?

Sinisa Hajnal 14-Sep-15 1:27am

Second query will occasionally return the wrong number. This will happen when two users increment at the same time. Database will dutyfuly update twice and both your users will get the same number back. I would advise you to put ctrl_last_no +1 into a variable, do the update then immediately (in the same stored procedure - or transaction if you're calling from the code) call insert.

deepankarbhatnagar 14-Sep-15 3:39am

Have you done any coding?

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)

sandeep Nishad · Answer 1 · 2015-09-13T22:35:00

Solution 1

first get last record.

SQL

select top 1 ctrl_last_no from CONTROL_FILE where ctrl_type = 'PKGNO' order by ctrl_last_no desc.

than store it any int variable than increment and insert in another table . or you can also write a stroed procedure/trigger for all above tasks(which is better approach)

Posted 13-Sep-15 22:35pm

sandeep Nishad

Updated 14-Sep-15 9:02am

v3