How to update more than 2 tables

Wrox Programmer Forums

		Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 2.0 > ASP.NET 2.0 Basics
How to update more than 2 tables

ASP.NET 2.0 Basics If you are new to ASP or ASP.NET programming with version 2.0, this is the forum to begin asking questions. Please also see the Visual Web Developer 2005 forum.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 2.0 Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

May 19th, 2006, 01:03 PM

walgr2k

walgr2k is offline

Registered User

Join Date: May 2006

Posts: 4

Thanks: 0

Thanked 0 Times in 0 Posts

Default

How to update more than 2 tables

I have created a detailsView on the page with the edit mode. I pull out the data from two base tables. If I want to update them, how can I update two tables simultaneously?
Thanks.

Old

May 19th, 2006, 02:01 PM

jbenson001 jbenson001 is offline

jbenson001 is offline

Friend of Wrox

Join Date: Nov 2003

Posts: 1,348

Thanks: 0

Thanked 5 Times in 5 Posts

Default

You will have to loop through the rows in the details view, pull out the data you need to inser for the table and do the insert, then do the same for table2.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
update to multiple tables	elania	PHP Databases	1	February 21st, 2005 03:10 PM
UPDATE with joined tables	DanKent	SQL Server 2000	4	July 6th, 2004 08:30 AM
Need help to update DB2 tables	lilychu	Classic ASP Databases	0	December 19th, 2003 02:49 PM
fields from tables to update	damnnono_86	Access	3	November 5th, 2003 04:07 AM
update tables	jjebb	Access	7	October 27th, 2003 12:26 PM