470,619 Members | 1,577 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,619 developers. It's quick & easy.

Using an INSERT Query as the value for the UpdateCommand property

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
0 1114

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

By using this site, you agree to our Privacy Policy and Terms of Use.