ASP.NET UpdateCommand with multiple tables updates
<p>I am using ASP.NET and using a grid with the UpdateCommand to update 2 tables
I have the following but doesn't seem to work as I do not get any errors but it simply does not update. From what you can see, am I on the right track?</p>

<pre><code>     UpdateCommand="UPDATE [tbl_ProgDt] SET [Type] = @type, [Identifiction] = @samplePoint WHERE [Seq] = @valID UPDATE [tbl_Prog] SET StoreNum = @storeNum WHERE ID = (SELECT ID FROM [tbl_ProgDt] WHERE [Seq] = @valID " &gt;


    &lt;UpdateParameters&gt;
      &lt;asp:Parameter Name="type" Type="String" /&gt;
      &lt;asp:Parameter Name="samplePoint" Type="String" /&gt;
      &lt;asp:Parameter Name="valID" Type="Int32" /&gt;
      &lt;asp:Parameter Name="storeNum" Type="Int32" /&gt;
       &lt;asp:Parameter Name="valID" Type="Int32" /&gt;
   &lt;/UpdateParameters&gt;
</code></pre>
