必须声明标量变量“@ ID”。如何解决这个错误 [英] Must declare the scalar variable "@ID". How to solve this error
问题描述
< asp：SqlDataSource ID =SqlDataSource1runat =serverConnectionString =<％$ ConnectionStrings：DBCon％> SelectCommand =SELECT * FROM [STUDENTS]
UpdateCommand =UPDATE [dbo]。[学生]设置
NAME = @ NAME，
[ADDRESS] = @ ADDRESS，
年龄= @年龄，
电子邮件= @ EMAIL，
DEPARTMENT = @ DEPARTMENT
WHERE ID = @ ID
DeleteCommand =DELETE FROM [dbo]。[学生] IDERE ID = @ID>
我尝试过：
< asp：SqlDataSource ID =SqlDataSource1runat =serverConnectionString = <％$ ConnectionStrings：DBCon％> SelectCommand =SELECT * FROM [STUDENTS]
UpdateCommand =UPDATE [dbo]。[学生]设置
NAME = @ NAME，
[ADDRESS] = @ ADDRESS，
年龄= @年龄，
电子邮件= @ EMAIL，
DEPARTMENT = @ DEPARTMENT
WHERE ID = @ ID
DeleteCommand =DELETE FROM [dbo]。[学生] WHERE ID = @ID>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:DBCon %>" SelectCommand="SELECT * FROM [STUDENTS] "
UpdateCommand="UPDATE [dbo].[STUDENTS] SET
NAME=@NAME,
[ADDRESS]=@ADDRESS,
AGE=@AGE,
EMAIL=@EMAIL,
DEPARTMENT=@DEPARTMENT
WHERE ID=@ID"
DeleteCommand ="DELETE FROM [dbo].[STUDENTS] WHERE ID = @ID">
What I have tried:
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:DBCon %>" SelectCommand="SELECT * FROM [STUDENTS] "
UpdateCommand="UPDATE [dbo].[STUDENTS] SET
NAME=@NAME,
[ADDRESS]=@ADDRESS,
AGE=@AGE,
EMAIL=@EMAIL,
DEPARTMENT=@DEPARTMENT
WHERE ID=@ID"
DeleteCommand ="DELETE FROM [dbo].[STUDENTS] WHERE ID = @ID">
推荐答案
ConnectionStrings：DBCon％>SelectCommand =SELECT * FROM [STUDENTS]
UpdateCommand =UPDATE [dbo]。[学生]设置
NAME = @ NAME，
[ADDRESS] = @ ADDRESS，
年龄= @年龄，
电子邮件= @ EMAIL，
DEPARTMENT = @ DEPARTMENT
WHERE ID = @ ID
DeleteCommand =DELETE FROM [dbo]。[学生] WHERE ID = @ID>
我尝试过：
< asp：SqlDataSource ID =SqlDataSource1 runat =serverConnectionString =<％
ConnectionStrings:DBCon %>" SelectCommand="SELECT * FROM [STUDENTS] "
UpdateCommand="UPDATE [dbo].[STUDENTS] SET
NAME=@NAME,
[ADDRESS]=@ADDRESS,
AGE=@AGE,
EMAIL=@EMAIL,
DEPARTMENT=@DEPARTMENT
WHERE ID=@ID"
DeleteCommand ="DELETE FROM [dbo].[STUDENTS] WHERE ID = @ID">
What I have tried:
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%
ConnectionStrings：DBCon％>SelectCommand =SELECT * FROM [STUDENTS]
UpdateCommand =更新[dbo]。[学生]设定
NAME = @ NAME，
[ADDRESS] = @ ADDRESS，
AGE = @ AGE，
EMAIL = @ EMAIL，
DEPARTMENT = @ DEPARTMENT
WHERE ID = @ ID
DeleteCommand = DELETE FROM [dbo]。[学生]其中ID = @ID>
ConnectionStrings:DBCon %>" SelectCommand="SELECT * FROM [STUDENTS] "
UpdateCommand="UPDATE [dbo].[STUDENTS] SET
NAME=@NAME,
[ADDRESS]=@ADDRESS,
AGE=@AGE,
EMAIL=@EMAIL,
DEPARTMENT=@DEPARTMENT
WHERE ID=@ID"
DeleteCommand ="DELETE FROM [dbo].[STUDENTS] WHERE ID = @ID">
你d o不将@ID参数传递给SQL：您需要设置 SqlDataSource.SelectParameters属性（System.Web.UI.WebControls） [ ^ ] - 该链接包含示例代码。
You do not pass the @ID parameter to SQL: you need to set the SqlDataSource.SelectParameters Property (System.Web.UI.WebControls)[^] - the link includes example code.
这篇关于必须声明标量变量“@ ID”。如何解决这个错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
