title: How to specify parameter value for stored procedure in SqlDataSource
body: <p>Being new to using the declarative syntax of SqlDataSource I am trying to figure out a way to set the value of a parameter to a stored procedure. I have a Client_ID that is passed via the Request Object and I need to set the Client_ID before the stored procedure of the SqlDataSource is executed.</p>
  
  <p>I have a couple of questions.</p>
  
  <ol>
  <li><p>Does the stored procedure parameter have to be predefined in the ASPX markup or can it be added dynamically in the code-behind?</p></li>
  <li><p>Would anyone have an example that demonstrates the SqlDataSource markup with a stored procedure and parameter as well as setting that parameter value in code-behind?</p></li>
  </ol>