这是我的存储过程
select @clientid=clientid,@points=points,@agentcode=agentcode from U_Client where userName=@ClientName
if @@RowCount=0
begin
set @returnString='errid=-3&err=用户名不存在'
goto SSend
end
SSend:
if @showText=1
select @returnString as jg在我的登录窗口执行时如何调用上面的set @returnString='errid=-3&err=用户名不存在',请各位帮忙解决下
select @clientid=clientid,@points=points,@agentcode=agentcode from U_Client where userName=@ClientName
if @@RowCount=0
begin
set @returnString='errid=-3&err=用户名不存在'
goto SSend
end
SSend:
if @showText=1
select @returnString as jg在我的登录窗口执行时如何调用上面的set @returnString='errid=-3&err=用户名不存在',请各位帮忙解决下
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@ClientName",SqlDbType.VarChar),
};
parms[0].Value = ClientName
SQLHelper.ExecuteNonQuery(connstring, CommandType.StoredProcedure, "存储过程名", parms);
object o = SQLHelper.ExecuteScalar(connstring, CommandType.StoredProcedure, "存储过程名", parms);