sqldatasource select parameter issue
the code :
<asp:SqlDataSource ID="ProductSource" runat="server"
SelectCommand="SELECT [PRODUCT_ID],[PRODUCT_NAME] from products where
STORE_ID=@STORE_ID"
ConnectionString="<%$ ConnectionStrings:Kernel_dbConnectionString %>" >
<SelectParameters><asp:SessionParameter Name="STORE_ID"
SessionField="SelectedStoreID" /></SelectParameters>
</asp:SqlDataSource>
an error accrued and it's : invalid column name STORE_ID
No comments:
Post a Comment