/// <summary> /// 执行指定事务的命令,指定参数值,返回DataTable. /// </summary> /// <remarks> /// 此方法不提供访问存储过程输入参数和返回值. /// 示例.: /// DataTable dt = ExecuteDataset(trans, "GetOrders", 24, 36); /// </remarks> /// <param name="transaction">事务</param> /// <param name="spName">存储过程名</param> /// <param name="parameterValues">分配给存储过程输入参数的对象数组</param> /// <returns>返回一个结果集</returns> public static DataTable ExecuteDataTable(SqlTransaction transaction, string spName, params object[] parameterValues) { return(DBHelperExt.ExecuteDataTable(DBHelper.ExecuteDataset(transaction, spName, parameterValues))); }
/// <summary> /// 执行指定事务的命令,指定参数,返回DataTable. /// </summary> /// <remarks> /// 示例: /// DataTable dt = ExecuteDataset(trans, CommandType.StoredProcedure, "GetOrders", new SqlParameter("@prodid", 24)); /// </remarks> /// <param name="transaction">事务</param> /// <param name="commandType">命令类型 (存储过程,命令文本或其它)</param> /// <param name="commandText">存储过程名或T-SQL语句</param> /// <param name="commandParameters">SqlParamter参数数组</param> /// <returns>返回一个包含结果集的DataTable</returns> public static DataTable ExecuteDataTable(SqlTransaction transaction, CommandType commandType, string commandText, params SqlParameter[] commandParameters) { return(DBHelperExt.ExecuteDataTable(DBHelper.ExecuteDataset(transaction, commandType, commandText, commandParameters))); }