Net Core教程

.Net 调用 sqlserver 存储过程实例

本文主要是介绍.Net 调用 sqlserver 存储过程实例,对大家解决编程问题具有一定的参考价值,需要的程序猿们随着小编来一起学习吧!

1.输出datatable

存储过程:

create proc inparamS

@inpar varchar(20)

as begin

select top 1 * from Address where City_Name=@inpar

end

.net调用

public static void GetProc()
{

static SqlConnection cn = new SqlConnection("server =.; database=bigdata;uid=ssa;pwd=123456");

SqlCommand cmd = new SqlCommand("inparamS", cn);
cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.AddWithValue("@inpar", "北京市");

cn.Open();


SqlDataReader sqlDataReder = cmd.ExecuteReader();
if (sqlDataReder.Read())
{

Console.WriteLine("The Result:" + sqlDataReder.GetString(0) + "///" + sqlDataReder.GetString(1));

}

cn.Close();

}

2.输出参数

存储过程:

alter proc inparamS

@inpar varchar(20) out

as begin

select top 1 @inpar=City_Name from Address

end

.net调用

public static void GetProc()
{

static SqlConnection cn = new SqlConnection("server =.; database=bigdata;uid=ssa;pwd=123456");

SqlCommand cmd = new SqlCommand("inparamS", cn);
cmd.CommandType = CommandType.StoredProcedure;

cn.Open();

 

cmd.Parameters.Add("@inpar", SqlDbType.VarChar, 20).Direction = ParameterDirection.Output;

 

cmd.ExecuteNonQuery();
string outParam = cmd.Parameters["@inpar"].Value.ToString();

 

Console.WriteLine("The Result:" + outParam);

cn.Close();

}

3.输出return值和输出参数

存储过程:

alter proc inparamS

@inpar varchar(20) out

as begin

select top 1 @inpar=City_Name from Address

if(@inpar='安徽省')
return 1
else
return 0

end

 

.net调用

public static void GetProc()
{

static SqlConnection cn = new SqlConnection("server =.; database=bigdata;uid=ssa;pwd=123456");

SqlCommand cmd = new SqlCommand("inparamS", cn);
cmd.CommandType = CommandType.StoredProcedure;

 

cmd.Parameters.Add("@retrun", SqlDbType.VarChar, 20).Direction = ParameterDirection.ReturnValue;

cmd.Parameters.Add("@inpar", SqlDbType.VarChar, 20).Direction = ParameterDirection.Output;

 

cmd.ExecuteNonQuery();
string res = cmd.Parameters["@retrun"].Value.ToString();
string address = cmd.Parameters["@inpar"].Value.ToString();

Console.WriteLine("The Result:" + res + "///" + address);

cn.Close();

}

这篇关于.Net 调用 sqlserver 存储过程实例的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!