title: Using parameters to configure the table name in an SqlDataSource SelectCommand
body: <p>I have an ASP.NET 3.5 web form with a DropDownList bound to a table of company names in a database. I also have a data bound GridView which I would like to update with data from the database depending on the company name selected in the DropDownList, so that the SelectCommand for the GridView's SqlDataSource is:</p>
  
  <pre><code>SELECT Registration, Telephone, Profile FROM {CompanyName}_VehicleData
  </code></pre>
  
  <p>Where {CompanyName} is whatever is selected in the DropDownList. I've used the Command and Parameter Editor to create a ControlParameter pointing to the SelectedValue of the DropDownList, but I don't know how to write the SelectCommand query to concatenate the parameter to '_VehicleData'. Any thoughts.</p>