62,041
社区成员
发帖
与我相关
我的任务
分享
alter proc CeshiReturnValue
(
@name varchar(50),
@age int
)as
declare @sql int
set @sql = (select count(1) from Ceshi where [name]=@name and age=@age)
if(@sql=0)
return 100
else
return 200
protected void Button3_Click(object sender, EventArgs e)
{
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = ConfigurationManager.ConnectionStrings["Connection"].ConnectionString;
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "CeshiReturnValue";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@name", SqlDbType.VarChar, 50).Value = "tt";
cmd.Parameters.Add("@age", SqlDbType.Int, 4).Value = 23;
cmd.Parameters.Add("ReturnValue", SqlDbType.Int, 4).Direction = ParameterDirection.ReturnValue;
cmd.ExecuteNonQuery();
Response.Write(cmd.Parameters["ReturnValue"].Value);
}
}
public static void RunProcedure(string strConnStr, string strSqlText, SqlParameter[] paras, out int ret)
{
ret = -1;
try
{
SqlConnection sqlConn = new SqlConnection();
sqlConn.ConnectionString = strConnStr;
sqlConn.Open();
SqlCommand sqlCmd = sqlConn.CreateCommand();
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandText = strSqlText;
sqlCmd.Parameters.Clear();
sqlCmd.Parameters.AddRange(paras);
SqlParameter retValue = new SqlParameter();
retValue.Direction = ParameterDirection.ReturnValue;
sqlCmd.Parameters.Add(retValue);
sqlCmd.ExecuteNonQuery();
ret = (int)retValue.Value;
sqlConn.Close();
}
catch (Exception ex)
{
throw ex;
}
}