best way to update a record.

  • Thread starter Thread starter pisquem
  • Start date Start date
P

pisquem

I have a web applicaiton that has a form that is used to update a
record from a sql table. This page will load with a value being
retrieved from a querystring.
The value is from the querystring and a call is made to a WS that
returns the record (that is to fill all the fields in the form) which
then allows the user to update this record. Not delete or add a new
record just update.
Having said that, with many different ways to do this, what is the best
way and recommended approach.

There are about 40 fields, which include drop down, radio buttons and
text area fields.
 
what is your question about? for representing control in good way or
how to update data?

the question how to update data?
ensure you are updating same data you are loaded. Lets imagine that
someone had loaded page but went on lunchand come back shortly,
Meantime someone else load same record and update data. The guy come
back from lunch and press update. If you just compare ID you will
update new values and will delete changed made by second guy.

about UI control: it is up to you. Talk with potential user, test how
fast they will enter data using different controls order. you have have
40 distinct fields you have 40 of them. User must fill all of them.
Appropriate way is using wizard pages and categorize controls.

I hope this helps
Galin Iliev[MCSD.NET]
www.galcho.com
 
This application will most likely be used by one person at a time as
opposed to many users so data refresh issues should not be a problem.
What is the recommended approach, use a dataset and populate a form and
fields with the databind fields then do an update on all fields when an
update button is clicked?
 
Back
Top