错误是：没有给出一个或多个必需参数的值。 [英] ERROR IS : No value given for one or more required parameters.

问题描述

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

推荐答案

ConnectionStrings：ConnectionString％>
SelectCommand = SELECT [ProductID ]，[名称]，[描述]，[价格]，[ImageUrl] FROM [产品] WHERE（[ProductID] = @ProductID） >
< SelectParameters>
< asp：QueryStringParameter Name = ProductID QueryStringField = ProductID Type = 十进制 />
< / SelectParameters >
< / asp：SqlDataSource > - ％GT;


我正在尝试在访问中转换SQL数据库但是它给出了错误没有给出一个或多个必需参数的值。 ..



< asp：AccessDataSource ID = AccessDataSource1 runat = server

< span class =code-attribute> DataFile = 〜/ App_Data / DatabasePCG03.mdb

SelectCommand = SELECT [ProductID]，[Name]，[Description]，[Price ]，[ImageUrl] FROM [Products] WHERE（[ProductID] = @ProductID） >
< SelectParameters >
< asp：QueryStringParameter 名称 = ProductID QueryStringField = ProductID 类型 = 十进制 / >
< / SelectParameters >
< / asp：AccessDataSource >


< / div >

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>

请，试试这个：

Please, try this:

SELECT [ProductID], [Name], [Description], [Price], [ImageUrl] FROM [Products] WHERE ([ProductID] = ?

或

or

PARAMETERS prodId INT;
SELECT [ProductID], [Name], [Description], [Price], [ImageUrl] FROM [Products] WHERE ([ProductID] = prodId

请看这里： ASP.NET中的参数查询MS Access [ ^ ]

http://www.evagoras.com/2011/02/08/calling ms从asp / 访问参数化查询[ ^ ]

PARAMETERS Declara （Microsoft Access SQL） [ ^ ]

Please,have a look here: Parameter Queries in ASP.NET with MS Access[^]
http://www.evagoras.com/2011/02/08/calling ms access parameterized queries from asp/[^]
PARAMETERS Declaration (Microsoft Access SQL)[^]

我认为您的数据库字段名称和选择命令字段不同请再次检查确定

i think your database field name and select command field is different please check it again ok

这篇关于错误是：没有给出一个或多个必需参数的值。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！