例如,我有一个存储过程如下:
CREATE PROCEDURE my_Procs
@partID varchar(18),
@errorMsg varchar(200) OUTPUT -- 用于输出错误信息
AS
IF (@partID == '')
BEGIN
SELECT @errorMsg = '料号为空'
RETURN
END

DECLARE @count int
SELECT @count = COUNT(*) FROM [Part] WHERE [PartID] = @partID
IF ( @count == 0 )
BEGIN
SELECT @errorMsg = '该料号不存在'
RETURN
END

DELETE * FROM [Part] WHERE [PartID] = @partID
IF ( @@error != 0 )
SELECT @errorMsg = '删除操作未完成'

我现在在.NET程序中调用此方法，该如何设置@errorMsg这个参数。
string strPartID = tbPartID.Text.Trim();
SqlCommand cmd = new SqlCommand()
cmd.CommandText = "my_Procs;
cmd.CommandType = CommandType.StoreProcedure;
cmd.Parameters.Add("@partID",strPartID);
cmd.Parameters.Add("@errorMsg", -------- 这里该怎么写？？？

不知是大家太过于谦虚,还是觉得问题过于简单,不肖一顾. 太冷漠了....

现公布我找到的大案,与大家分享
string strMsg;
string strPartID = tbPartID.Text.Trim();
SqlCommand cmd = new SqlCommand()
try
{
cmd.Connection = conn;
if(conn.State != ConnectionState.Open)
{
conn.Open();
}
cmd.CommandText = "my_Procs";
cmd.CommandType = CommandType.StoreProcedure;
cmd.Parameters.Add("@partID",SqlDbType.Varchar,16)
cmd.Parenters["@partID"].Value = strPartID;
cmd.Parameters.Add("@errorMsg,sqlDbType.Varchar,200);
cmd.Parameters["@errorMsg"].Direction = ParameterDirection.Output; // 表示为输出参数,
cmd.ExecuteNonQuery();
}
catch
{
strMsg = cmd.Parameters["@errorMsg"].Value.ToString();
MessageBox.Show(strMsg,"错误",MessageBoxButtons.Ok,MessageBoxIcon.Error);
}
Finally
{
if(conn.State != ConnectionState.Closed)
{
conn.Close();
}
}

[此贴子已经被作者于2007-9-4 0:43:27编辑过]