i have a database and i create a form with button edit,delete, New Registration..using Formview in asp.net..
everything was working good...
And i write SQL statement to get New ID number into dropdownlist/TextBox when i click button "New Registration".
i can get new(next) ID number after read database
it's also working good
Now i want change it to get ID which was deleted from table and replace
the ID with new record...what i need is when i click "New Registration" i
want get deleted "ID" first and then go to new record ID...
my code is here:-it working for get next ID after read database.
FROM (SELECT ID + 1 AS PANG
EXCEPT SELECT ID FROM Table1)
AS boon WHERE PANG >300000
View Complete Post