Question

这个存储过程在winform中如何调用？？

CREATE proc gx
@ss varchar(20),
@tt varchar(20)
as
declare @hh varchar(20)
select @hh=ID from zskcc where mc=@ss
update zskcc set PID=@hh where mc=@tt
GO

ss 和tt是要传递的参数。多谢！

Answer 1

SqlConnection conn = new SqlConnection("连接字符串");
cmd = new SqlCommand("gx",conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@ss", ss的值);
cmd.Parameters.AddWithValue("@tt", tt的值);
if (cmd.Connection.State == ConnectionState.Closed) cmd.Connection.Open();
cmd.ExecuteScalar();
if (cmd.Connection.State == ConnectionState.Open) cmd.Connection.Close();
cmd.Dispose();
conn.Dispose();

Answer 2

exec gx @ss='值ss',@tt='值tt'
or
exec gx '值ss','值tt'
和调普通的SQL语句一样就可以