ERROR The variable name '@' has already been declared

[Rohan Danushka]

Hi,

Please help me with this.

System.Data.SqlClient.SqlException: 'The variable name '@MBid' has already been declared. Variable names must be unique within a query batch or stored procedure.'


Public Function SYSSerial() As Boolean
If K9ConfigConn.State = ConnectionState.Closed Then K9ConfigConn.Open()
DR.Close()

Dim PCMBid As String = K9Core.GetSysSerialNo
Dim PCCPUid As String = K9Core.GetCPUID

CMD.Connection = K9ConfigConn
CMD.CommandType = CommandType.Text
With CMD
.Parameters.AddWithValue("@MBid", PCMBid)
.Parameters.AddWithValue("@CPUid", PCCPUid)
End With
CMD.CommandText = "SELECT * FROM k9info WHERE mbid=@MBid AND cpuid=@CPUid"

DR = CMD.ExecuteReader()

If DR.Read = True Then
Return True
wasSuccessful = True
ElseIf DR.Read = False Then
Return False
wasSuccessful = False
End If

CMD.Dispose()
K9ConfigConn.Close()

If wasSuccessful = True Then Return True Else Return False
End Function




Thank you....


RohanD

Continue reading...