Please go through this situation.
My asp page having 'ONLY ONE' record from database containing 150 text box fields.
User can modify any field but at the time of saving, some set of the fields should be updated into database and other set of fields into an xml file for later verification. This selection condition is dynamic for each text fields.
Since the page contains only one record from database table, the Update statement of stored procedure contains all the 150 records.
My plan is to keep old values in text boxes before the user making any change, and at the time of saving, set old value or new value to string variables and pass these variable to procedure.
I couldn't find any way to sort this out. I tried using hidden variables to store values, but at the time of saving, i'm unable to set old or new values into string variable. This was one way of thought, but can do any possible way to achive this.
Friends, any ideas..?
Am using C#, asp.net, SQL server.
Thanks in advance.
View Complete Post