<div> <%--<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT [ProductID], [Name], [Description], [Price], [ImageUrl] FROM [Products] WHERE ([ProductID] = @ProductID)"> <SelectParameters> <asp:QueryStringParameter Name="ProductID" QueryStringField="ProductID" Type="Decimal" /> </SelectParameters> </asp:SqlDataSource>--%> I'M TRYING TO CONVERT SQL DATABASE IN ACCESS .. BUT IT IS GIVING ERROR " No value given for one or more required parameters ". .. <asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/App_Data/DatabasePCG03.mdb" SelectCommand="SELECT [ProductID], [Name], [Description], [Price], [ImageUrl] FROM [Products] WHERE ([ProductID] = @ProductID)"> <SelectParameters> <asp:QueryStringParameter Name="ProductID" QueryStringField="ProductID" Type="Decimal" /> </SelectParameters> </asp:AccessDataSource> </div>
SELECT [ProductID], [Name], [Description], [Price], [ImageUrl] FROM [Products] WHERE ([ProductID] = ?
PARAMETERS prodId INT; SELECT [ProductID], [Name], [Description], [Price], [ImageUrl] FROM [Products] WHERE ([ProductID] = prodId
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)