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

显示全部楼层 · 2011-4-22 02:11:57

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

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

千问 · 2011-4-22 02:11:57

<pre id=\"best-answer-content\" class=\"reply-text mb10\">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();