Wednesday, 28 August 2013

sqldatasource select parameter issue

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