editing multiple datalist items at once

B

Brian

I'm trying to create an editing interface for a product database and
I'm still mostly in the planning stage.

The client wants an easy to update page with a table that essentially
has two columns:

Product Price

In the database these are stored in different tables and in practice
there is also user information, role information, product approval
information, category information, etc etc. So the resulting query is
done with multiple joins.

I was hoping for a layout that had the product names displayed on the
left and the corresponding prices displayed in a textbox on the right,
with an 'update' button at the bottom of the page.

I figured the best control for this was probably a datalist.

I thought that the submit event could update the dataset and then I
could update the database based on the state of the dataset row (ie if
it was modified then perform an update). Though I'm a bit stuck about
where to go with this.

Efficiency isn't as crucial here since it's the admin side of things
but still it's a consideration.

Should I be pulling the dataset with multiple tables and using the
command builder to update changes? It worried me that maybe the
tables pulled would be too large (with too many products). How large
is too large I wonder.

So I guess there are two real questions here:

Should I use a datalist for this type of multiple edit with one update
button? (I'm assuming that I'd do it without any sort of edit
template)

How do I best capture/update the changes to the database?

thanks,
Brian
 
B

Brian

possible answer here:
http://msdn.microsoft.com/library/d...questionsaboutaspnetdatagridservercontrol.asp

under the topic
"Editing Multiple Rows At Once"

(I had been looking before I posted and just hadn't found anything ...
seems like as soon as I post I find something -- is there some sort of
reverse murphy's law that applies to newsgroups?)

Though this uses a datagrid it might solve my problem nicely. If it
doesn't then I'll be back with more questions.

Thanks for reading.
:)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,744
Messages
2,569,482
Members
44,900
Latest member
Nell636132

Latest Threads

Top