[.NET] 必須宣告純量變數
請輸入專案類型(網站專案或者應用程式專案)：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
推
01/05 13:08, , 1F
01/05 13:08, 1F
推
01/05 13:09, , 2F
01/05 13:09, 2F
→
01/05 13:10, , 3F
01/05 13:10, 3F
討論串 (同標題文章)
完整討論串 (本文為第 1 之 2 篇)：