Thanks. So an example is lets say I have a listing of employee attributes :Age,Sex,Race,Weight,Religion.
Lets say Age Sex and Race are from table A, and Religion is from table B. To display the data I did a SELECT .....INNER JOIN WHERE A.Id=B.Id in my SelectCommand of the SqlDataSource Control. Now my question is, for the UpdateCommand how do I use one UPDATE statement to update both table A and B? Thanks for any insight. Jon I used the <EditItemTemplate> to display them and give the user the chance to modify them. On Nov 4, 7:54 am, Chuck <[EMAIL PROTECTED]> wrote: > Are you wanting to restrict/reduce the amount of times you hit the > database with statements, or you simply want to have one - and only > one - SQL UPDATE statement update 'n' amount tables at the same time? > More info is definitely needed. > > However, I don't believe you can have one Update statement update > multiple tables at the same time, unless you concatenate multiple > UPDATE statements together. I heard and read that doing sql > concatenation is 'the work of the devil,' especially if you adding > fields from objects such as textboxes. It would be sql injection > prone. > > Give more info please. > > On Nov 3, 11:27 pm, BigJ <[EMAIL PROTECTED]> wrote: > > > Is it possible to do an update on multiple tables within 1 statement?
