用SqlHelper类为什么返回不了值呢？
string adUrl = " ";
int spRst=0;
SqlParameter[] parms = {
new SqlParameter( "@UserId ", SqlDbType.Int,4),
new SqlParameter( "@UserIp ", SqlDbType.NVarChar,50),
new SqlParameter( "@ReURL ", SqlDbType.NVarChar,1000),
new SqlParameter( "@return ", SqlDbType.Int,4)
};
parms[0].Value = _userid;
parms[1].Value = GuestInfo.GetIP();
parms[2].Direction = ParameterDirection.Output;
parms[3].Direction = ParameterDirection.Output;
SqlHelper.ExecuteNonQuery(new CONN(adDbName).ConnString, "Guest_User_SP ",parms);
adUrl=parms[2].Value.ToString();
spRst=(int)parms[3].Value;
执行时一说是没有实例对象～～
[解决办法]
检查 GuestInfo,new CONN(adDbName).ConnString两处
[解决办法]
估计是SqlHelper.ExecuteNonQuery(new CONN(adDbName).ConnString, "Guest_User_SP ",parms);有问题,SqlHelper.ExecuteNonQuery确定没错?
再来就看new CONN(adDbName).ConnString
[解决办法]
我也想知道，我也遇到过同样的问题
[解决办法]
public static int ExecuteNonQuery(SqlTransaction trans, CommandType cmdType, string cmdText, params SqlParameter[] commandParameters) {
SqlCommand cmd = new SqlCommand();
PrepareCommand(cmd, trans.Connection, trans, cmdType, cmdText, commandParameters);
int val = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
return val;
}
注意: cmd.Parameters.Clear();
[解决办法]
你不RETURN,怎么有返回值?
