title: Multiple INSERT statements on one SqlDataSource
body: <p>For a 'new record' site I have a <code>FormView</code> attached to an <code>SqlDataSource</code>. The user inputs the data and the <code>InsertCommand</code> has the SQL INSERT statement. The thing is that I want to do other queries as part of the initialization, and these queries involve other tables.</p>
  
  <p>Basically I want to execute all these queries when the user clicks the "Insert" button.
  The first INSERT gets the values from the input form, but the other three are always the same.</p>
  
  <pre><code>INSERT INTO proceso (nombreProceso, macroProceso, analista_id)
  VALUES (@nombreProceso,@macroProceso,@analista_id)
  INSERT INTO marcador_progreso (marcador_id,state,proceso_id) VALUES (1,'False',@id)
  INSERT INTO marcador_progreso (marcador_id,state,proceso_id) VALUES (2,'False',@id) 
  INSERT INTO marcador_progreso (marcador_id,state,proceso_id) VALUES (3,'False',@id) 
  </code></pre>
  
  <p>When I run this, the first statement apparently gets executed (i.e a new <code>proceso</code> record gets inserted) but the other 3 INSERTs do not. How should I proceed to solve this?</p>
  
  <p>The SqlDataDource contains the id parameter</p>
  
  <pre><code> &lt;InsertParameters&gt;
       ... a few parameters...
       &lt;asp:Parameter Name="id" /&gt;
  &lt;/InsertParameters&gt;
  </code></pre>