sqlcommand对象的Parameters集合是SqlParameterCollection了类型,是SqlParameter的集合。 SqlParameter主要是为sqlcommand提供参数。大多用于存储过程。如在SQL Server中定义如下的存储过程:
Create Procedure TestProcedure
(
@au_idIN varchar (11),
)
AS
select A.au_fname, A.au_lname, T.title
from authors as A join titleauthor as TA on
A.au_id=TA.au_id
join titles as T
on T.title_id=TA.title_id
where A.au_id=@au_idIN
return (5)
您可以使用SqlParameter为@au_idIN参数提供值。
Create Procedure TestProcedure
(
@au_idIN varchar (11),
)
AS
select A.au_fname, A.au_lname, T.title
from authors as A join titleauthor as TA on
A.au_id=TA.au_id
join titles as T
on T.title_id=TA.title_id
where A.au_id=@au_idIN
return (5)
您可以使用SqlParameter为@au_idIN参数提供值。