<div>
i am not getting ur question...<br />
<br />
In the above case ...u cannot have two statements combine...<br />
<br />
but u can use the insert statement first and then select so u can get the inserted data displayed.<br />
<br />
-Rons
</div>


i am not getting ur question...

In the above case ...u cannot have two statements combine...

but u can use the insert statement first and then select so u can get the inserted data displayed.

-Rons

<div>
<div class="content wysiwyg-content">
Hello Experts,<br />
<br />
I have two statements and wish to only have one as when ran with two they counter act each other and the info is added to the table but not displayed:<br />
<br />
<br />
<br />
Displays the info i want: &nbsp;<br />
<br />
queryString = &quot;select * from tCart where OrderNbr = &quot;&nbsp;+ OrderNbHS;<br />
<br />
<br />
Copies the info i want: &nbsp; &nbsp;<br />
<br />
queryString = &quot;INSERT INTO [tOrderDetail] SELECT [pcode],[qty],[OrderNbr] FROM [tCart] WHERE OrderNbr = &quot;&nbsp;+ OrderNbHS;<br />
<br />
Thank You!
</div>
</div>


Hello Experts,

I have two statements and wish to only have one as when ran with two they counter act each other and the info is added to the table but not displayed:



Displays the info i want:  

queryString = "select * from tCart where OrderNbr = " + OrderNbHS;


Copies the info i want:    

queryString = "INSERT INTO [tOrderDetail] SELECT [pcode],[qty],[OrderNbr] FROM [tCart] WHERE OrderNbr = " + OrderNbHS;

Thank You!

Display and Insert SQL queryString, ASP.net

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).