how to synchronize sql row number with the ID column automatically
I'm using a listbox with insert/update/delete buttons on ASP.NET side,
when I delete a student, the student ID is not equal with ID column
anymore. Therefore when I delete a student, the order in listbox is not
equal to SQL side. How can I automatically synchronize these two? I have
set primary key and Identity Specification Set to Active, for your
information. and included screenshots of the problem below.
http://i.stack.imgur.com/SEcsL.png
http://i.stack.imgur.com/0h2iI.png
No comments:
Post a Comment