必须声明标量变量“@ CODE”。 [英] Must declare the scalar variable "@CODE".

问题描述

我正在开发vb.net应用程序并在以下代码中收到错误。错误是必须声明标量变量@CODE。

I'm developing vb.net application and receiving error in following code. error is Must declare the scalar variable "@CODE".

Dim load As SearchFromTable = New SearchFromTable
        Dim xcommad As OleDb.OleDbCommand = load.xCommand

        Dim xQry As String = "insert into TBLCLASS (CODE,CNAME,CSEC) Values (@CODE,@CNAME,@CSEC)"

        Try

            With fObjects.CommandObject(xQry, fObjects.ConnectionObject)
                      .Parameters.Add(New OleDb.OleDbParameter("@CODE", OleDb.OleDbType.VarChar, 250)).Value = Me.MTextbox1.Text
                .Parameters.Add(New OleDb.OleDbParameter("@CNAME", OleDb.OleDbType.VarChar, 250)).Value = Me.MTextbox2.Text
                .Parameters.Add(New OleDb.OleDbParameter("@CSEC", OleDb.OleDbType.VarChar, 250)).Value = Me.MCombobox1.Text

                
                load.GetMyData(xQry)
            End With

        Catch ex As Exception
            MsgBox("Failed because: " & ex.Message)

        End Try

推荐答案

根据文档 [ ^ ]在声明变量时，您不需要@字符。

According to the documentation[^] you do not need the "@" character when declaring the variable.

这篇关于必须声明标量变量“@ CODE”。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！