错误代码如下:
<!--
Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/
-->
public static void ExecuteParameterSQL(string asName)
{
sConnectionString = ConfigurationManager.AppSettings.Get("UserConnection");
OracleConnection ocConnection = new OracleConnection(sConnectionString);
ocConnection.Open();
OracleCommand ocCommand = ocConnection.CreateCommand();
ocCommand.CommandType = CommandType.Text;
ocCommand.CommandText = @"select EMPLOYEEID,EMPLOYEENAME from ORGANIZATION_EMPLOYEE
where EMPLOYEENAME=@loginName";
OracleParameter opName = new OracleParameter();
opName.ParameterName = "loginName";
opName.OracleType = OracleType.VarChar;
opName.Value = asName;
ocCommand.Parameters.Add(opName);
int i = (int)ocCommand.ExecuteNonQuery();
ocConnection.Close();
}
将SQL语句修改如下,运行没有问题。注意代码中红色部分。
<!--
Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/
--> /// <summary>
/// 执行参数
/// </summary>
/// <param name="asName"></param>
public static void ExecuteParameterSQL(string asName)
{
sConnectionString = ConfigurationManager.AppSettings.Get("UserConnection");
OracleConnection ocConnection = new OracleConnection(sConnectionString);
ocConnection.Open();
OracleCommand ocCommand = ocConnection.CreateCommand();
ocCommand.CommandType = CommandType.Text;
ocCommand.CommandText = @"select EMPLOYEEID,EMPLOYEENAME from ORGANIZATION_EMPLOYEE
where EMPLOYEENAME=:loginName";
OracleParameter opName = new OracleParameter();
opName.ParameterName = "loginName";
opName.OracleType = OracleType.VarChar;
opName.Value = asName;
ocCommand.Parameters.Add(opName);
int i = (int)ocCommand.ExecuteNonQuery();
ocConnection.Close();
}: