how to increment value and insert into database

narasiman rao

11y993C#

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
Update control_file set ctrl_last_no = ctrl_last_no + 1 where ctrl_type = 'PKGNO'

Second Query as follows
select * from CONTROL_FILE where ctrl_type = 'PKGNO'

i get the ctrl_last_nor from control file table and increment one value.

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#.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sujeet Suman11y ago
Your whole task may divided into 2 parts:
Part - 1:
Increase table "control_file" column "ctrl_last_no" by 1. (You done well)

Part - 2:
Add that newly incremented value of column "ctrl_last_no"
To table "Co_Package_Master" column "cpm_pkg_id", which is a string

For your second task you need to concatenate column "cpm_pkg_id" with "ctrl_last_no" (because directly you cannot increment string value)

you can checkout below references:
http://www.codeproject.com/Articles/417084/Auto-incremented-ID-with-NVARCHAR-VARCHAR-datatype
http://www.c-sharpcorner.com/UploadFile/ff2f08/auto-incremented-column-with-varchar-and-nvarchar-data-type/
http://forums.asp.net/t/1883145.aspx?Can+we+Auto+increment+on+varchar+data+type+like+this+
0
Manas Mohapatra11y ago
Please follow below link to implement the same.

http://www.c-sharpcorner.com/UploadFile/ff2f08/auto-incremented-column-with-varchar-and-nvarchar-data-type/

If you are facing any issue share error details here.
0