Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to: Refer to the values from a column
Message
From
12/05/2004 09:27:29
 
 
To
12/05/2004 08:35:26
Bill Benton
North Florida Software Services
Middleburg, Florida, United States
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Miscellaneous
Thread ID:
00902399
Message ID:
00903142
Views:
28
Bill,

>>I am not using the CommandBuilder! Should I be?

Well, the error message:

Exception Details: System.InvalidOperationException: Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information.

indicates that you're using the UpdateCommand and that it hasn't been properly generated, which means that the CommandBuilder is being used, because the CommandBuilder automatically generates an UpdateCommand for you. Part of my problem with answering this question is that you're using MM which throws in an additional layer of complexity which I know nothing about.

So, Kevin, or someone who uses MM, would be a better choice for answering this question, but since you directed it at me, I thought I should at least give you a reply.

Does MM possibly uses CommandBuilder behind the scenes? I don't know.
Is it optional to use so that you can roll your own UpdateCommand? I don't know.
Is it set up so that you don't even have to use the UpdateCommand but can totally roll your own Data Updates (which is what I do, BTW)? I don't know.
These are the kinds of answers you need.

~~Bonnie
Bonnie Berent DeWitt
NET/C# MVP since 2003

http://geek-goddess-bonnie.blogspot.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform