string sqlCmd = @"SELECT r.row_id AS resp_id,
r.name AS resp_name
FROM srb.s_resp r,
srb.s_per_resp pr,
srb.s_contact c,
srb.s_user u
WHERE r.row_id = pr.resp_id
AND u.row_id = c.row_id
AND c.person_uid = pr.per_id
AND UPPER(u.login) = @login
ORDER BY r.name";
OracleConnection con = new OracleConnection(getConnectionString(username, password));
OracleCommand command = con.CreateCommand();
conSiebel.Open();
command.CommandType = CommandType.Text;
command.Connection = con;
command.CommandText = sqlCmd;
command.Parameters.Add(new OracleParameter("login", username));
IDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection);
reader.Close();
我试图将@login
参数添加到上面的查询中,但它没有被添加。有人可以帮我解决这个问题吗?
ParameterDirection
。 - CDove