C# 2.0 Vista,sql2000带返回值存储过程调用

sql 2000 code:

 

 1IF EXISTS (SELECT name FROM sysobjects 
 2         WHERE name = 'Proc_Unite_Delete' AND type = 'P')
 3 DROP PROCEDURE Proc_Unite_Delete
 4GO
 5CREATE PROCEDURE  Proc_Unite_Delete
 6    @UniteID INT,
 7        @Return VARCHAR(300) OUTPUT
 8AS
 9DECLARE @Ccount int, @Pcount int
     SELECT @Ccount=COUNT(*) FROM C_Physician WHERE UniteID=@UniteID
     SELECT @Pcount=COUNT(*) FROM Physician WHERE UniteID=@UniteID
--SELECT @Ccount
--SELECT @Pcount
    IF exists(SELECT * FROM Unite WHERE UniteID=@UniteID) AND @Ccount=0 AND @Pcount=0        
    BEGIN  
         
        DELETE FROM Unite            
        WHERE UniteID=@UniteID
        SET @Return='成功'
        --PRINT 'OK'
    RETURN 1
    
    END
        SET @Return='不成功'
        --PRINT 'NO'
    RETURN 0
    
GO
---测试代码
DECLARE @srturn VARCHAR(300) ,@id int
set @id=6
EXEC Proc_Unite_Delete 6,@Return=@srturn OUTPUT
SELECT @srturn

c#2.0 code:

 1DialogResult dr =MessageBox.Show("是否真的要删除?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
 2            if (dr == DialogResult.Yes)
 3            {
 4                try
 5                {
 6                    DBConnectioin dbc = new DBConnectioin();
 7                    SqlConnection conn = new SqlConnection(DBConnectioin.conStr);
 8                    conn.Open();
 9                    SqlCommand cmd = new SqlCommand("Proc_Unite_Delete", conn);//调用存储过程
                    cmd.CommandType = CommandType.StoredProcedure;
                    SqlParameter pares = new SqlParameter("@UniteID", SqlDbType.Int, 8);//输入参数
                    SqlParameter pares1 = new SqlParameter("@Return", SqlDbType.VarChar, 30);//输出参数
                    cmd.Parameters.Add(pares);
                    cmd.Parameters.Add(pares1);
                    cmd.Parameters["@UniteID"].Value = Int32.Parse(this.txtUniteID.Text.Trim());
                    cmd.Parameters["@Return"].Direction = ParameterDirection.Output;
                    cmd.ExecuteNonQuery();
                    String Retur = (string)cmd.Parameters["@Return"].Value;
                    conn.Close();
                    MessageBox.Show("删除"+Retur, "提示");
                    this.FrmUnite_Load(sender, e);
                }
                catch (Exception ex)
                { }

 1 DialogResult dr =MessageBox.Show("是否真的要删除?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
 2             if (dr == DialogResult.Yes)
 3             {
 4                 try
 5                 {
 6                     DBConnectioin dbc = new DBConnectioin();
 7                     SqlConnection conn = new SqlConnection(DBConnectioin.conStr);
 8                     conn.Open();
 9                     SqlCommand cmd = new SqlCommand("Proc_Unite_Delete", conn);//调用存储过程
10                     cmd.CommandType = CommandType.StoredProcedure;
11                     SqlParameter pares = new SqlParameter("@UniteID", SqlDbType.Int, 8);//输入参数
12                     SqlParameter pares1 = new SqlParameter("@Return", SqlDbType.VarChar, 30);//输出参数
13                     cmd.Parameters.Add(pares);
14                     cmd.Parameters.Add(pares1);
15                     cmd.Parameters["@UniteID"].Value = Int32.Parse(this.txtUniteID.Text.Trim());
16                     cmd.Parameters["@Return"].Direction = ParameterDirection.Output;
17                     cmd.ExecuteNonQuery();
18                     String Retur = (string)cmd.Parameters["@Return"].Value;
19                     conn.Close();
20                     MessageBox.Show("删除"+Retur, "提示");
21                     this.FrmUnite_Load(sender, e);
22                 }
23                 catch (Exception ex)
24                 { }