存储过程的输出参数asp.net C# [英] Stored procedure output parameter asp.net c#
问题描述
我是新来的存储过程的世界。
I'm new to stored procedure world.
我们现有的系统与现有的存储过程,检查用户名和URL路径。存储过程将检查用户的详细信息是否存在。如果存在,返回值为1,如果没有返回值0
We have existing system with existing stored procedure, which checks username and url path. Stored procedure will check whether user details exist. If exists return value 1 if not return value 0
我要的是写asp.net C#code此存储过程。传递用户信息和路径,之后返回0或1。
All I want is writing asp.net c# code for this stored procedure. Passing user details and path and returning 0 or 1 after that.
如果返回值是1,允许用户如果0然后重定向到不同的页面
If return value is 1, allow user if it 0 then redirect to different page
下面链接的SQL Server执行存储过程
Below link for SQL Server execute stored procedure
http://www.natboxservices.com/helmshore/img/pic.jpg
pciated任何帮助AP $ P $
any help appreciated
感谢
推荐答案
看起来像你需要存储过程输出参数
Looks like you need stored procedure with output parameter
int errorId = 0;
using(SqlConnection sqlConnection = new SqlConnection(connectionString))
{
using(SqlCommand cmd = new SqlCommand("YourStoredProcedureName", sqlConnection))
{
cmd.CommandType=CommandType.StoredProcedure;
SqlParameter parm=new SqlParameter("@username", SqlDbType.VarChar);
parm.Value="mshiyam";
parm.Direction =ParameterDirection.Input ;
cmd.Parameters.Add(parm);
SqlParameter parm2=new SqlParameter("@path",SqlDbType.VarChar);
parm2.value = "Some Path";
parm2.Direction=ParameterDirection.Output;
cmd.Parameters.Add(parm2);
SqlParameter parm3 = new SqlParameter("@errorId",SqlDbType.Int);
parm3.Direction=ParameterDirection.Output;
cmd.Parameters.Add(parm3);
sqlConnection.Open();
sqlConnection.ExecuteNonQuery();
errorId = cmd.Parameters["@errorId"].Value; //This will 1 or 0
}
}
这篇关于存储过程的输出参数asp.net C#的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!