ASP.NET UpdateCommand with multiple tables updates

[Adamz]

I am using ASP.NET and using a grid with the UpdateCommand to update 2 tablesI 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?\[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 " > <UpdateParameters> <asparameter Name="type" Type="String" /> <asparameter Name="samplePoint" Type="String" /> <asparameter Name="valID" Type="Int32" /> <asparameter Name="storeNum" Type="Int32" /> <asparameter Name="valID" Type="Int32" /> </UpdateParameters>\[/code\]