Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Update SQL Database thru Datasets when Joins are Involved
Message
Information générale
Forum:
ASP.NET
Catégorie:
The Mere Mortals .NET Framework
Titre:
Update SQL Database thru Datasets when Joins are Involved
Versions des environnements
Environment:
C# 1.1
OS:
Windows XP
Network:
Windows 2000 Server
Database:
MS SQL Server
Divers
Thread ID:
01055659
Message ID:
01055659
Vues:
55
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform