定义了一个变量
OracleParameter[] parameters ={
new OracleParameter("FunName",OracleType.NVarChar,50),
new OracleParameter("Level1",OracleType.Number)
};
想再加一项,如new OracleParameter("Level2",OracleType.Number)请教
OracleParameter[] parameters ={
new OracleParameter("FunName",OracleType.NVarChar,50),
new OracleParameter("Level1",OracleType.Number)
};
想再加一项,如new OracleParameter("Level2",OracleType.Number)请教
new OracleParameter("FunName",OracleType.NVarChar,50),
new OracleParameter("Level1",OracleType.Number) ,
new OracleParameter("Level2",OracleType.Number)
};
OracleParameter[] parameters ={
new OracleParameter("FunName",OracleType.NVarChar,50),
new OracleParameter("Level1",OracleType.Number) ,
new OracleParameter("Level2",OracleType.Number)
};
OracleParameter[] parameters ={
new OracleParameter("FunName",OracleType.NVarChar,50),
new OracleParameter("Level1",OracleType.Number)
};
再加一项new OracleParameter("Level2",OracleType.Number)
即parameters的长度增加1,并得到新项
list.Add(new OracleParameter("Level2",OracleType.Number));
list.Add(new OracleParameter("Level1",OracleType.Number));
new OracleParameter("FunName",OracleType.NVarChar,50),
new OracleParameter("Level1",OracleType.Number)
};private OracleCommand BuildIntCommand(string storedProcName, OracleParameter[] parameters)
{
OracleCommand command = new OracleCommand(storedProcName, cn);
command.CommandType = CommandType.StoredProcedure; foreach (OracleParameter parameter in parameters)
{
command.Parameters.Add(parameter);
} command.Parameters.Add(new OracleParameter("Level2", OracleType.Number)); return command;
}
parameters[1]=new OracleParameter("@b","1");
parameters[2]=new OracleParameter("@c","1");
parameters[3]=new OracleParameter("@d","1");
parameters[4]=new OracleParameter("@e","1");
parameters[5]=new OracleParameter("@f","1");
parameters[6]=new OracleParameter("@g","1");
parameters[7]=new OracleParameter("@h","1");以后直接用 parameters;