关于存储过程的问题？？

[ztx998]

如果存储过程有多个参数，用command如何调用？？

希望以插入一条记录为例讲解一下如何调用！！！

[morefish]

dbCommand.Parameters.Add( new SqlParameter(@PP,SqlDbType.Int));
dbCommand.Parameters.Add( new SqlParameter(@Str,SqlDbType.Text,8));

dbCommand.Parameters[@pp].Value = pp;
dbCommand.Parameters[@Str].Value = str;

[snowjin78]

con.Open()
Dim cmd As OleDbCommand = New OleDbCommand("SP_Insertstall", con)
cmd.CommandType = CommandType.StoredProcedure
Dim parameters As IDataParameter() = { _
New OleDbParameter("sp_ckbm", OleDbType.VarChar, 10), _
New OleDbParameter("sp_hpbm", OleDbType.VarChar, 15), _
New OleDbParameter("sp_hpmc", OleDbType.VarChar, 20), _
New OleDbParameter("sp_BZ", OleDbType.VarChar, 100)}
parameters(0).Value = DrpListstorehouse.SelectedItem.Value
parameters(2).Value = NewStallName.Text
parameters(1).Value = NewStallNumber.Text
parameters(3).Value = Newbeizhu.Text
Dim parameter As OleDbParameter
For Each parameter In parameters
cmd.Parameters.Add(parameter)
Next

Dim result As New OleDbParameter("sp_result", OleDbType.Integer)
result.Direction = ParameterDirection.Output
cmd.Parameters.Add(result)
cmd.ExecuteNonQuery()
con.Close()

If result.Value = -1 Then
' If Add returned -1, the sort was already present
AddNewError.Visible = True
End If

[CMIC]

CREATE PROCEDURE sp1
(@a int,
@b int) as
insert into t1
(a,b)
values
{@a,@b}

SqlCommand cmicCmd=new SqlCommand("sp1",Cn);
cmicCmd.CommandType=CommandType.StoredProcedure;
cmicCmd.Parameters.Add(new SqlParameter("@a",SqlDbType.Int);
cmicCmd.Parameters.Add(new SqlParameter("@b",SqlDbType.Int);
cmicCmd.ExecuteNonQuery();

[ztx998]

3q