Ok I have a drop down list populated with user names.  I want my end user to be able to select a user name and then have it update the calendar with the user's calendar info.

My SqlDataSource is somethign like select * from xxx where username=@userName

How do I pass that DropDownList1.SelectedValue to the Sql statement? 

Hi Ron,

Click the smart tag of the datasource (in design view) and you can setup the datasource to lookup the value of the control. In the code below, the datasource will look for the categoryid from the spinedit control:

        <asp:AccessDataSource ID="AccessDataSource1" runat="server" 

            DataFile="~/App_Data/nwind.mdb" 

            SelectCommand="SELECT [CategoryID], [CategoryName] FROM [Categories] WHERE ([CategoryID] = ?)">

            <SelectParameters>

                <asp:ControlParameter ControlID="ASPxSpinEdit1" DefaultValue="1" 

                    Name="CategoryID" PropertyName="Number" Type="Int32" />

            </SelectParameters>

        </asp:AccessDataSource>