作者b8888 (b8888)
看板Visual_Basic
标题[.NET] 必须宣告纯量变数
时间Fri Jan 4 09:51:14 2013
请输入专案类型(网站专案或者应用程式专案)：ASP.NET
各位好
请问我在执行下列指令时会出现
必须宣告纯量变数 "@id_no"。
的错误讯息，请问该如何修正??
(以"纯"的sql指令执行是OK的)
先谢谢大家
Protected Sub Button2_Click(ByVal sender As Object, ByVal e As
System.EventArgs) Handles Button2.Click
Try
Dim Conn As SqlConnection = New SqlConnection
Conn.ConnectionString =
WebConfigurationManager.ConnectionStrings
("SqlConn").ConnectionString
Conn.Open()
Dim cmd As SqlCommand = New SqlCommand("insert into
FileStore(id_no,title_nm,file_nm,class_no,user_no) values
(@id_no,@title_nm,@file_nm,@class_no,@user_no)", Conn)
Dim sqlPara As New SqlParameter()
'id_no nchar 20 , tabl 栏位layout
sqlPara.ParameterName = "@id_no"
sqlPara.SqlDbType = SqlDbType.Char
sqlPara.Value = "A111"
sqlPara.Size = 20
'title_nm nchar 50 , tabl 栏位layout
sqlPara.ParameterName = "@title_nm"
sqlPara.SqlDbType = SqlDbType.Char
sqlPara.Value = "222"
sqlPara.Size = 50
'file_nm nchar 20 , tabl 栏位layout
sqlPara.ParameterName = "@file_nm"
sqlPara.SqlDbType = SqlDbType.Char
sqlPara.Value = "3333"
sqlPara.Size = 50
'class_no nchar 10 , tabl 栏位layout
sqlPara.ParameterName = "@class_no"
sqlPara.SqlDbType = SqlDbType.Char
sqlPara.Value = "222"
sqlPara.Size = 10
'user_no nchar 10 , tabl 栏位layout
sqlPara.ParameterName = "@user_no"
sqlPara.SqlDbType = SqlDbType.Char
sqlPara.Value = "222"
sqlPara.Size = 10
'==此段为先前执行 insert 测试，是OK的
'Dim cmd As SqlCommand = New SqlCommand("insert into
'FileStore(id_no,title_nm,file_nm,class_no,user_no) values
'('111','222','33','44','55')", Conn)
'=================================================
cmd.Parameters.Add(sqlPara)
cmd.ExecuteNonQuery()
Conn.Dispose()
Catch ex As Exception
Response.Write(ex.Message)
End Try
End Sub
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 114.40.197.169
1F：推 fumizuki:每一个参数定义前都要 New SqlParameter 01/05 13:08
2F：推 fumizuki:不然就是一直在设定同一个参数的属性.. 01/05 13:09
3F：→ fumizuki:每一个参数定义完成後也都要Parameters.Add... 01/05 13:10