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:
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.
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...
<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> |