hi frnds
i had got a problem,
i want to increase the serial number automatically when page is loaded and it will be inserted into the database......
pls reply me answer....
here i use vb.net coding.........
kanuri1 -2 Junior Poster in Training
Recommended Answers
Jump to PostThe easiast way to increment a number by 1 is to do it directly in the SQL-query.
For example:
UPDATE table1 SET serialnumber = serialnumber + 1 WHERE id = <id>
All 3 Replies
Oxiegen 88 Basically an Occasional Poster Featured Poster
The easiast way to increment a number by 1 is to do it directly in the SQL-query.
For example: UPDATE table1 SET serialnumber = serialnumber + 1 WHERE id = <id>
love_dude1984 0 Junior Poster in Training
Which database ur using?if SQL05 thn simply change the Identity specification property of the column to yes..it will automatically increment the value in that column.
Ezzaral 2,714 Posting Sage Team Colleague Featured Poster
Please do post the same question in multiple threads. I am closing this one. Please direct any discussion to the other thread: http://www.daniweb.com/forums/thread247968.html
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.