C#带输出参数的存储过程调用

1. 存储过程

1 create procedure UP_GetMaxgkrq   
2 @maxdatetime datetime output   
3 as   
4 select @maxdatetime=max(gkrq) from t_lpxx_case_1


程序 
1 SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString);   
2 conn.Open();   
3 SqlCommand cmd = new SqlCommand("UP_GetMaxgkrq",conn);   
4 cmd.CommandType = CommandType.StoredProcedure;   
5 cmd.Parameters.Add("@maxdatetime", SqlDbType.DateTime);   
6 cmd.Parameters["@maxdatetime"].Direction = ParameterDirection.Output;   
7 cmd.ExecuteNonQuery();   
8 return cmd.Parameters["@maxdatetime"].Value.ToString();


2. 示例存储过程

 1 create PROCEDURE UP_t_collection_GetMaxId   
 2 AS   
 3 DECLARE @TempID int   
 4 SELECT @TempID = max([id])+1 FROM t_collection   
 5 IF @TempID IS NULL   
 6 RETURN 1   
 7 ELSE   
 8 RETURN @TempID  
 9 程序  
10 using (SqlConnection connection = new SqlConnection(connectionString)) {   
11 int result;   
12 connection.Open();   
13 SqlCommand command = BuildIntCommand(connection, storedProcName, parameters);   
14 cmd.Parameters.Add(new SqlParameter("ReturnValue",   
15 SqlDbType.Int, 4, ParameterDirection.ReturnValue,   
16 false, 0, 0, string.Empty, DataRowVersion.Default, null));   
17 cmd.ExecuteNonQuery();   
18 //int result = (int)cmd.Parameters["ReturnValue"].Value;   
19 return cmd.Parameters["ReturnValue"].Value.ToString();  
20 }


转自福星论坛

posted @ 2012-01-16 15:00  kumat  阅读(452)  评论(0)  编辑  收藏  举报