Use control parameters to bind a controls value to a particular parameter within a sql statement

Control parameters to select record details (ddlists)

Reference:

You can automatically bind a control to a parameter's value by using a control called a asp:controlparameter. For instance, if you had a sql statment that requires an input parameter for a select statement, you can bind that @parametername to a fictional control called ddlItems or something by utilizing the following code:

<asp:sqlDataSource id="ds1" ru.... selectcommand="Select * from Users where id = @id">
   <select parameters>
      <asp:controlparameter controlid="ddlItems" Name="ItemID"
            PropertyName="SelectedValue"
            Type="String"/>
  </selectparameters>
 

 
Maint