<div>
This solution is an obious one, i've asked if thers a possibility to somehow oweride the data adater which throws exception on my try to update using the da.Update() without witting custom update code....(i've implemented instead of triggers)
</div>


This solution is an obious one, i've asked if thers a possibility to somehow oweride the data adater which throws exception on my try to update using the da.Update() without witting custom update code....(i've implemented instead of triggers)

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
1. I have a view i sql2k db with 2 databases in it &amp;&nbsp;instead of update trigger - they work 100%<br />
2. I use data adapter to generate dynamic sql update command (in need it to be dynamic).<br />
3. When i update my data adapter (after RefreshSchema() in sqlcommandbuilder with data adapter) i recieve the following error :<br />
&quot;dynamic sql generation is not supported against multiple base tables&quot;<br />
<br />
How can i override command builder so that he will generate the command text (sql statement) but will not try to check if the view is with more that one table ?
</div>
</div>


Hi

1. I have a view i sql2k db with 2 databases in it & instead of update trigger - they work 100%
2. I use data adapter to generate dynamic sql update command (in need it to be dynamic).
3. When i update my data adapter (after RefreshSchema() in sqlcommandbuilder with data adapter) i recieve the following error :
"dynamic sql generation is not supported against multiple base tables"

How can i override command builder so that he will generate the command text (sql statement) but will not try to check if the view is with more that one table ?

.NET Question: SqlCommandBuilder dinamic sql question

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.