title: How to set parameters for SqlDataSource UpdateCommand
body: <p>For a Gridview:</p>
  
  <p>I am trying to use a stored procedure for the first time in a SQLDataSource for the UpdateCommand:</p>
  
  <pre><code>&lt;asp:SqlDataSource ID="TECT_DataSource" runat="server"
      ConnectionString="&lt;%$ ConnectionStrings:OracleConnectionString %&gt;" 
      ProviderName="&lt;%$ ConnectionStrings:OracleConnectionString.ProviderName %&gt;"
      SelectCommand="SELECT MPID, User_Id, Last_Name, First_Name
                     FROM Scripts.vw_Tect_Exam"
      UpdateCommand="P_TECT_UPD_EXAM_ID" UpdateCommandType="StoredProcedure"&gt;  
      &lt;UpdateParameters&gt;                    
          &lt;asp:Parameter Name="MPID" Type="Int32"  /&gt;  
          &lt;asp:Parameter Name="User_Id" Type="String" /&gt;   
      &lt;/UpdateParameters&gt; 
  &lt;/asp:SqlDataSource&gt;
  </code></pre>
  
  <p>I am wondering how the UpdateParameters get their values set, since I only specify a name?<br>
  The procedure <code>P_TECT_UPD_EXAM_ID</code> expects two parameters as input: <code>"in_MPID"</code> and <code>"in_UserId"</code><br>
  I am also wondering how to map those values to the input parameters for the procedure as the names are different?</p>