title: Creating dynamic SQL DbParameter values
body: <p>First time user - hoping this is in the right format:</p>
  
  <p>I am wanting to know if I can create SQL DbParameter values, esp on the ParamaterName.</p>
  
  <p>My current code is:</p>
  
  <pre><code>DbCommand dbCommand = SqlDb.GetStoredProcCommand(uspCommand);
  DbParameter ProcessedFileName = dbCommand.CreateParameter();
  ProcessedFileName.DbType = DbType.String;
  ProcessedFileName.ParameterName = "@FileName";
  ProcessedFileName.Value = pstrProcessedFileName;
  dbCommand.Parameters.Add(ProcessedFileName);
  </code></pre>
  
  <p>I am wanting to add:</p>
  
  <pre><code>ProcessedFileName.ParameterName = "@FileName1";
  ProcessedFileName.ParameterName = "@FileName2";
  ProcessedFileName.ParameterName = "@FileName3";
  ProcessedFileName.ParameterName = "@FileName4";
  </code></pre>
  
  <p>with the <code>@FileNames</code> coming from an array.</p>