Here's my code:
Dim Cmd as New SQLCommand(sqlString, conn)
cmd.CommandType=CommandType.StoredProcedure
Breaks Here -->>cmd.parameters.add(New SQLParameter(@.OrdAlias, OrdNum))
cmd.parameters.add(New SQLParameter(@.AliasSourceCode, 4))
The error says:
compilation error - -
then, on the line that is in red:
Compiler Error Message:BC30037: Character is not valid.
I have 'OrdNum' declared globally, and OrdNum is assigned right away in the Page_Load event. I've checked the spelling of the SQL parameters (OrdAlias is a varchar, and AliasSourceCode is a tinyInt)
After all this - then, this code runs
Any ideas why I'm getting this error??
Tuesday, February 14, 2012
Character is not valid error
Labels:
breaks,
character,
cmd,
code,
commandtypecommandtype,
conn,
database,
dim,
error,
gtgtcmd,
microsoft,
mysql,
oracle,
parameters,
server,
sql,
sqlcommand,
sqlstring,
storedprocedure,
valid
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment