Row Click Expaning to DetailTable Issue

[Shawn]

I have a table that I want to expand the row and display the Detail Table when the row is clicked by the user.  I achieve that like so:

If e.CommandName = "RowClick" Then
            Dim item As GridDataItem = e.Item
            If item.Expanded = True Then
                item.Expanded = False
            Else
                item.Expanded = True
            End If
        End If

However I get an error on the "item.expanded = true"

Procedure or function 'sp_Select_Affiliate_Purchased_Breakdown' expects parameter '@source_id', which was not supplied.

<asp:SqlDataSource ID="sqlds_AffiliatePurchasedData" runat="server"
        ConnectionString="<%$ ConnectionStrings:Company_Master_ConnectionString %>"
        SelectCommand="sp_Select_Affiliate_Purchased_Breakdown"
        SelectCommandType="StoredProcedure">
        <SelectParameters>
            <asp:Parameter Name="source_id" Type="Int32" DefaultValue="@source_id" />
        </SelectParameters>
    </asp:SqlDataSource>

Why would this be happening?  The Parameter is right in the data source...

[Shinu]

Hi Shawn,

I am not sure how you are passing value for the parameter. One suggestion will be to pass the value for the parameter in the ItemCommand event which will be called each and every time you click a row.

Thanks
Shinu.