change registrationID in the database..
old ID -- textbox1.text
new ID -- textbox2.text
when user enter its old id and new id then on click of submit button old id will be replaced by new id in database..
db: RegistrationNum-- varchar(200)
simply i want to check that the value which i am inserting in the oldRegID.Text exists into the database..
if yes, then it will update that id with the text inserted into the NewRigID.Text..
Else it will give an error--"Please enter your old registrationID Correctly"
This is what i want..