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

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.

Thank you
David Martin
Next
Reply
Map
View

Click here to load this message in the networking platform