1.?帶參數的存儲過程
set
ANSI_NULLS
ON
set
QUOTED_IDENTIFIER
ON
GO
ALTER
PROCEDURE
[
dbo
]
.
[
sp_select_gua
]
@num
int
AS
BEGIN
--
SET NOCOUNT ON added to prevent extra result sets from
--
interfering with SELECT statements.
SET
NOCOUNT
ON
;
select
mean
from
tb_gua
where
id
=
@num
END
C#中的調用
conn.Open();
SqlCommand cmd
=
new
SqlCommand();
cmd.CommandType
=
CommandType.StoredProcedure;
cmd.CommandText
=
"
sp_select_gua
"
;
cmd.Connection
=
conn;
cmd.Parameters.Add(
new
SqlParameter(
"
@num
"
, SqlDbType.Int));
cmd.Parameters[
"
@num
"
].Value =
Calculator();
c
= (
string
)cmd.ExecuteScalar();
2.?帶rerurn的存儲過程
?
set
ANSI_NULLS
ON
set
QUOTED_IDENTIFIER
ON
GO
ALTER
PROCEDURE
[
dbo
]
.
[
sp_select_gua2
]
(
@num1
int
,
@num2
int
)
AS
BEGIN
--
SET NOCOUNT ON added to prevent extra result sets from
--
interfering with SELECT statements.
SET
NOCOUNT
ON
;
return
@num1
+
@num2
;
END
C#中的調用
conn.Open();
SqlCommand cmd
=
new
SqlCommand();
cmd.CommandType
=
CommandType.StoredProcedure;
cmd.CommandText
=
"
sp_select_gua2
"
;
cmd.Connection
=
conn;
cmd.Parameters.Add(
new
SqlParameter(
"
@num1
"
, SqlDbType.Int));
cmd.Parameters[
"
@num1
"
].Value =
Calculator();
cmd.Parameters.Add(
new
SqlParameter(
"
@num2
"
, SqlDbType.Int));
cmd.Parameters[
"
@num2
"
].Value =
Calculator();
cmd.Parameters.Add(
new
SqlParameter(
"
@return
"
, SqlDbType.Int));
cmd.Parameters[
"
@return
"
].Direction =
ParameterDirection.ReturnValue;
cmd.ExecuteNonQuery();
c
= cmd.Parameters[
"
@return
"
].Value.ToString();
３． 帶output參數的調用
set
ANSI_NULLS
ON
set
QUOTED_IDENTIFIER
ON
GO
ALTER
PROCEDURE
[
dbo
]
.
[
sp_select_gua1
]
(
@num
int
,
@guamean
nvarchar
(
1000
)
=
''
output,
@guaname
nvarchar
(
10
)
=
''
output)
AS
BEGIN
--
SET NOCOUNT ON added to prevent extra result sets from
--
interfering with SELECT statements.
SET
NOCOUNT
ON
;
select
@guaname
=
name,
@guamean
=
mean
from
tb_gua
where
id
=
@num
END
C#中的調用
conn.Open();
SqlCommand cmd
=
new
SqlCommand();
cmd.CommandType
=
CommandType.StoredProcedure;
cmd.CommandText
=
"
sp_select_gua1
"
;
cmd.Connection
=
conn;
cmd.Parameters.Add(
new
SqlParameter(
"
@num
"
, SqlDbType.Int));
cmd.Parameters[
"
@num
"
].Value =
Calculator();
cmd.Parameters.Add(
new
SqlParameter(
"
@guamean
"
, SqlDbType.NVarChar,
1000
));
cmd.Parameters[
"
@guamean
"
].Direction =
ParameterDirection.Output;
cmd.Parameters.Add(
new
SqlParameter(
"
@guaname
"
, SqlDbType.NVarChar,
10
));
cmd.Parameters[
"
@guaname
"
].Direction =
ParameterDirection.Output;
cmd.ExecuteNonQuery();
c
= cmd.Parameters[
"
@guamean
"
].Value.ToString();
d
= cmd.Parameters[
"
@guaname
"
].Value.ToString();
?
更多文章、技術交流、商務合作、聯系博主
微信掃碼或搜索：z360901061
微信掃一掃加我為好友
QQ號聯系： 360901061
您的支持是博主寫作最大的動力，如果您喜歡我的文章，感覺我的文章對您有幫助，請用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧，狠狠點擊下面給點支持吧，站長非常感激您！手機微信長按不能支付解決辦法：請將微信支付二維碼保存到相冊，切換到微信，然后點擊微信右上角掃一掃功能，選擇支付二維碼完成支付。
【本文對您有幫助就好】元
