Click to See Complete Forum and Search --> : Updating data


howardnl
June 21st, 2002, 11:16 AM
Hello,

I've got a page where a persons name and phone number can
be updated. The name is in a text box. The phone
information is in a separate table because there can be
multiple phone numbers. Right now I am using a datagrid to
display the phone information directly from the database.
My problem is that I have a button that lets the user
insert a new phone number. What's the best way to do this?
I know I shouldn't hit the database everytime I insert a
new record, but I'm new to this stuff and I'm not sure how
to do it. I've also got a delete button. I don't want to
hit the database everytime, only when I initially get the
data and then update the data when the user hits the
submit button.

Thanks for any help, I really appreciate it.

Thanks,
Nick

cocolovevienna
June 25th, 2002, 07:21 PM
use a new form to get phone.take the phone into array[],then update datebase one time.