System.Data.OleDb.OleDbParameter myParam;
String sql = "ModFunc";
OleDbCommand myCommand = new OleDbCommand(sql, myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
myParam = myCommand.Parameters.Add("p_Roleid",OleDbType.VarChar,5);
myParam.Value =q_roleid;
myParam = myCommand.Parameters.Add("p_Funcid",OleDbType.VarChar,5);
myParam.Value =S_id;
myCommand.Connection.Open();
try
{
myCommand.ExecuteNonQuery();
Message.Text = "<b>已修改权限</b>";
}
catch (Exception e)
{
Message.Text = "错误:未能添加记录!";
Message.Style["color"] = "red";
}
myCommand.Connection.Close();给你个调用的例子
String sql = "ModFunc";
OleDbCommand myCommand = new OleDbCommand(sql, myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
myParam = myCommand.Parameters.Add("p_Roleid",OleDbType.VarChar,5);
myParam.Value =q_roleid;
myParam = myCommand.Parameters.Add("p_Funcid",OleDbType.VarChar,5);
myParam.Value =S_id;
myCommand.Connection.Open();
try
{
myCommand.ExecuteNonQuery();
Message.Text = "<b>已修改权限</b>";
}
catch (Exception e)
{
Message.Text = "错误:未能添加记录!";
Message.Style["color"] = "red";
}
myCommand.Connection.Close();给你个调用的例子
以前只用过 SQL Connection
连接没有问题,就是在
OracleParameter num = new OracleParameter("num",OracleType.Number);
有个 InvalidCastException 异常,但是系统并没有抛出
到myOracleCommand.ExecuteNonQuery();抛出了异常
我是说你这句参数的类型和长度没指定。
OracleParameter num = new OracleParameter("yhdm",OracleType.Number);