Queried Data to be Updated
Posted on 2006-03-30
Here is my situation:
A value is entered into a textbox. This value is then used against a query that fills several other textboxes. The values that are entered into all the textboxes need to then be inserted, updated or deleted against the database.
I've tried binding the textboxes to a dataset and using a data adapter to update it, but I can't figure out how to get it to query the record and update the database.
Should I use a series of sqlcommands instead? Is the data adapter a better route? How can I make this work? Please include sample code.