By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,262 Members | 2,664 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,262 IT Pros & Developers. It's quick & easy.

Using an INSERT Query as the value for the UpdateCommand property

P: n/a
I want to use an INSERT Query as the value for the UpdateCommand property of
an SQL datasource, anyone know if this will actually work ?

The reason i want to do it is bacause i am taking values from tablea and
binding them to controls, whose values i want to insert into tableb. I am
using a detailsview control to do the databinding. If the detailsview is in
edit mode then it displays the data from table A in the bound testbox
controls in the templatefield but obviously they are blank in insert mode.
However i want the textbox values to default to the values from table A when
they are to be inserted into table B. I thought the easiest way to do this
without having to programatically assign Test property of 30+ text boxes
everytime the detailsview changed into insert mode, was to use edit mode
instead but run an insert query rather than an update query. Will this work,
or is there a much better way of doing it?
Apr 5 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.