FormView not updating with control events
<p>Time for my daily ASP.NET question.</p>

<p>One of my pages shows all of our customer information from a customer table.  I want the user to choose whether to see all customer records, or select a specific record from a list.  So, my webpage has two radio buttons (show all customers, show specific customer), a listbox (full of customer names), and a formview control.  The problem I'm having is getting the formview to update when I change modes via radio buttons or listbox selection (see code below).</p>

<p>Can anyone provide me with some pointers on how to do what I'm trying to do?</p>

<pre><code>protected void Page_Load(object sender, EventArgs e)
{
    UpdatePage ();
}

protected void RadioButtonShowAll_CheckedChanged(object sender, EventArgs e)
{
}

protected void RadioButtonShowSelected_CheckedChanged(object sender, EventArgs e)
{
}

protected void DropDownListCustomers_SelectedIndexChanged(object sender, EventArgs e)
{
    RadioButtonShowSelected.Checked = true;
    UpdatePage ();
}

protected void UpdatePage ()
{
    if (RadioButtonShowAll.Checked)
        SqlDataSource1.SelectCommand = "SELECT * FROM [Customer] ORDER BY [Company]";
    else
        SqlDataSource1.SelectCommand = "SELECT * FROM [Customer] WHERE ([CustomerID] = @CustomerID) ORDER BY [Company]";

    FormView1.DataBind();
}
</code></pre>
