.net调用sql存储过程

  /// 执行一段SQL语句通过output参数返回结果
                /// </summary>
                /// <param name="sConnStr"/>连结字符串</param>
                /// <param name="sSql" />需执行的Sql语句</param>
                /// <returns>返回结果</returns>
                public static string ExecuteQueryOutput(string sConnStr,string sSql)
                {
                        SqlCommand cmd = null;
                        try
                        {
                                cmd = new SqlCommand(sSql);
                                cmd.Connection = new SqlConnection(sConnStr);
                                cmd.CommandType=CommandType.StoredProcedure;
                                cmd.Connection.Open();
                                SqlParameter mypara=cmd.Parameters.Add("@reValue",SqlDbType.VarChar,200);
                                mypara.Direction=ParameterDirection.Output;
                                cmd.ExecuteNonQuery();
                                string reValue=(string)cmd.Parameters["@reValue"].Value.ToString();
                                return reValue;
                        }
                        finally
                        {
                                cmd.Connection.Close();
                                if(cmd != null) cmd.Dispose();
                        }
                }