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:29:54
Bill Benton
North Florida Software Services
Middleburg, Florida, United States
 
 
To
12/05/2004 09:27:29
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Miscellaneous
Thread ID:
00902399
Message ID:
00903143
Views:
23
>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

Thanks, Bonnie!
Bill Benton
Senior Systems Analyst
Nuvell Financial Services
Previous
Reply
Map
View

Click here to load this message in the networking platform