What is the best way to go about storing original textbox values, so that when a user changes them, I can compare the two and run the correct SQL statement?
Example:
select case newval
case 0
delete statement
case else
if oldval>0 then
update statement
else
insert statement
end if
end select
I have the record key and newval values, I just need oldval. I've read some about storing them when the listview is bound to the data, but I seemed to be only storing zeroes, which probably means that I was storing the pre-bound value. I tried to use the OnDataBound event to store textbox.text in oldval. What should I do? What are some ways to do this?