[Quote=引用 14 楼 yanning9090 的回复:]
而且会出现一个对话框说:
The source file is defferent from when the module was built.Would you like the debugger to use it anyway?
不论我选什么都是老样子!
[/Quote]
public static int ExecuteNonQuery(string connectionString, CommandType cmdType, string cmdText, params OracleParameter[] commandParameters)
{
// Create a new Oracle command
OracleCommand cmd = new OracleCommand();
//Create a connection
using (OracleConnection connection = new OracleConnection(connectionString))
{
//Prepare the command
PrepareCommand(cmd, connection, null, cmdType, cmdText, commandParameters);
//Execute the command
int val = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
return val;
}
}
public int UpdateCustomerSiteNo(int id,string siteno)
{
OracleParameter[] opp = new OracleParameter[] {
new OracleParameter("i_id",OracleType.Number),
new OracleParameter("i_site_no",OracleType.VarChar,30),
new OracleParameter("i_flag",OracleType.Number)
};
opp[0].Value = id;
opp[1].Value = siteno;
opp[2].Direction = ParameterDirection.Output;