Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update SQL Database thru Datasets when Joins are Involve
Message
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Environment versions
Environment:
C# 1.1
OS:
Windows XP
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01055659
Message ID:
01056091
Views:
16
David,

> I am getting the following error : "Dynamic SQL generation is not supported against multiple base tables" when I try to update my SQL Database from my DataSet (which uses a SELECT Statement containing a JOIN).
>
>Does anyone have an easy way around this in Mere Mortals? Will I need to use Stored Procedures?
>
>Any replies are appreciated.

The most straightforward way is to used stored procedures. ADO.NET is not especially tuned for updating multiple back end tables from a single DataTable.

Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com
Previous
Reply
Map
View

Click here to load this message in the networking platform