コード例 #1
0
 /// <summary>
 /// 提供通用的调用存储过程的方法(通过参数查询数据)
 /// </summary>
 /// <param name="procedureName">存储过程名称</param>
 /// <param name="sqlParameters">存储过程参数数组</param>
 /// <param name="dt">返回表</param>
 /// <returns></returns>
 public static bool ExecuteStoredProcedure(string procedureName, ref SqlParameter[] sqlParameters, out DataTable dt, out string errorMessage)
 {
     return(SQLCommon.ExecuteStoredProcedure(procedureName, ApplicationConfig.connectionString, ref sqlParameters, out dt, out errorMessage));
 }
コード例 #2
0
        /// <summary>
        /// 通过存储过程查询数据
        /// </summary>
        /// <param name="procedureName">存储过程名称</param>
        /// <param name="dt">返回表</param>
        /// <returns></returns>
        public static bool ExecuteStoredProcedure(string procedureName, out DataTable dt)
        {
            string errMessage;

            return(SQLCommon.ExecuteStoredProcedure(procedureName, ApplicationConfig.connectionString, out dt, out errMessage));
        }