Cells.ImportDataReader

ImportDataReader(SqlDataReader, int, int, bool)

Imports data from a SqlDataReader object.

[Obsolete("Use Cells.ImportData(IDataReader, int, int,ImportTableOptions) method, instead.")]
[EditorBrowsable(EditorBrowsableState.Never)]
public int ImportDataReader(SqlDataReader reader, int firstRow, int firstColumn, bool insertRows)
ParameterTypeDescription
readerSqlDataReaderThe SqlDataReader object which contains data.
firstRowInt32The row number of the first cell to import in.
firstColumnInt32The column number of the first cell to import in.
insertRowsBooleanIndicates whether extra rows are added to fit data.

Return Value

Total number of rows imported.

Remarks

NOTE: This member is now obsolete. Instead, please use Cells.ImportData(IDataReader, int, int,ImportTableOptions) method. This property will be removed 12 months later since December 2018. Aspose apologizes for any inconvenience you may have experienced.

See Also


ImportDataReader(SqlDataReader, bool, int, int, bool)

Imports data from a SqlDataReader object.

[Obsolete("Use Cells.ImportData(IDataReader, int, int,ImportTableOptions) method, instead.")]
[EditorBrowsable(EditorBrowsableState.Never)]
public int ImportDataReader(SqlDataReader reader, bool isFieldNameShown, int firstRow, 
    int firstColumn, bool insertRows)
ParameterTypeDescription
readerSqlDataReaderThe SqlDataReader object which contains data.
isFieldNameShownBooleanIndicates whether the field name of the data reader will be imported to the first row.
firstRowInt32The row number of the first cell to import in.
firstColumnInt32The column number of the first cell to import in.
insertRowsBooleanIndicates whether extra rows are added to fit data.

Return Value

Total number of rows imported.

Remarks

NOTE: This member is now obsolete. Instead, please use Cells.ImportData(IDataReader, int, int,ImportTableOptions) method. This property will be removed 12 months later since December 2018. Aspose apologizes for any inconvenience you may have experienced.

See Also


ImportDataReader(SqlDataReader, bool, int, int, bool, string, bool)

Imports data from a SqlDataReader object.

[Obsolete("Use Cells.ImportData(IDataReader, int, int,ImportTableOptions) method, instead.")]
[EditorBrowsable(EditorBrowsableState.Never)]
public int ImportDataReader(SqlDataReader reader, bool isFieldNameShown, int firstRow, 
    int firstColumn, bool insertRows, string dateFormatString, bool convertStringToNumber)
ParameterTypeDescription
readerSqlDataReaderThe SqlDataReader object which contains data.
isFieldNameShownBooleanIndicates whether the field name of the data reader will be imported to the first row.
firstRowInt32The row number of the first cell to import in.
firstColumnInt32The column number of the first cell to import in.
insertRowsBooleanIndicates whether extra rows are added to fit data.
dateFormatStringStringDate format string for cells.
convertStringToNumberBooleanIndicates if this method will try to convert string to number.

Return Value

Total number of rows imported.

Remarks

NOTE: This member is now obsolete. Instead, please use Cells.ImportData(IDataReader, int, int,ImportTableOptions) method. This property will be removed 12 months later since December 2018. Aspose apologizes for any inconvenience you may have experienced.

See Also


ImportDataReader(OleDbDataReader, bool, int, int, bool, string, bool)

Imports data from a OleDbDataReader object.

[Obsolete("Use Cells.ImportData(IDataReader, int, int,ImportTableOptions) method, instead.")]
[EditorBrowsable(EditorBrowsableState.Never)]
public int ImportDataReader(OleDbDataReader reader, bool isFieldNameShown, int firstRow, 
    int firstColumn, bool insertRows, string dateFormatString, bool convertStringToNumber)
ParameterTypeDescription
readerOleDbDataReaderThe OleDbDataReader object which contains data.
isFieldNameShownBooleanIndicates whether the field name of the data reader will be imported to the first row.
firstRowInt32The row number of the first cell to import in.
firstColumnInt32The column number of the first cell to import in.
insertRowsBooleanIndicates whether extra rows are added to fit data.
dateFormatStringStringDate format string for cells.
convertStringToNumberBooleanIndicates if this method will try to convert string to number.

Return Value

Total number of rows imported.

Remarks

NOTE: This member is now obsolete. Instead, please use Cells.ImportData(IDataReader, int, int,ImportTableOptions) method. This property will be removed 12 months later since December 2018. Aspose apologizes for any inconvenience you may have experienced.

See Also


ImportDataReader(OleDbDataReader, bool, int, int, bool)

Imports data from a OleDbDataReader object.

[Obsolete("Use Cells.ImportData(IDataReader, int, int,ImportTableOptions) method, instead.")]
[EditorBrowsable(EditorBrowsableState.Never)]
public int ImportDataReader(OleDbDataReader reader, bool isFieldNameShown, int firstRow, 
    int firstColumn, bool insertRows)
ParameterTypeDescription
readerOleDbDataReaderThe OleDbDataReader object which contains data.
isFieldNameShownBooleanIndicates whether the field name of the data reader will be imported to the first row.
firstRowInt32The row number of the first cell to import in.
firstColumnInt32The column number of the first cell to import in.
insertRowsBooleanIndicates whether extra rows are added to fit data.

Return Value

Total number of rows imported.

Remarks

NOTE: This member is now obsolete. Instead, please use Cells.ImportData(IDataReader, int, int,ImportTableOptions) method. This property will be removed 12 months later since December 2018. Aspose apologizes for any inconvenience you may have experienced.

See Also


ImportDataReader(OleDbDataReader, int, int, bool)

Imports data from a OleDbDataReader object.

[Obsolete("Use Cells.ImportData(IDataReader, int, int,ImportTableOptions) method, instead.")]
[EditorBrowsable(EditorBrowsableState.Never)]
public int ImportDataReader(OleDbDataReader reader, int firstRow, int firstColumn, bool insertRows)
ParameterTypeDescription
readerOleDbDataReaderThe OleDbDataReader object which contains data.
firstRowInt32The row number of the first cell to import in.
firstColumnInt32The column number of the first cell to import in.
insertRowsBooleanIndicates whether extra rows are added to fit data.

Return Value

Total number of rows imported.

Remarks

NOTE: This member is now obsolete. Instead, please use Cells.ImportData(IDataReader, int, int,ImportTableOptions) method. This property will be removed 12 months later since December 2018. Aspose apologizes for any inconvenience you may have experienced.

See Also


ImportDataReader(IDataReader, bool, int, int, bool, string, bool)

Imports data from a IDataReader object.

[Obsolete("Use Cells.ImportData(IDataReader, int, int,ImportTableOptions) method, instead.")]
[EditorBrowsable(EditorBrowsableState.Never)]
public int ImportDataReader(IDataReader reader, bool isFieldNameShown, int firstRow, 
    int firstColumn, bool insertRows, string dateFormatString, bool convertStringToNumber)
ParameterTypeDescription
readerIDataReaderThe IDataReader object which contains data.
isFieldNameShownBooleanIndicates whether the field name of the data reader will be imported to the first row.
firstRowInt32The row number of the first cell to import in.
firstColumnInt32The column number of the first cell to import in.
insertRowsBooleanIndicates whether extra rows are added to fit data.
dateFormatStringStringDate format string for cells.
convertStringToNumberBooleanIndicates if this method will try to convert string to number.

Return Value

Total number of rows imported.

Remarks

NOTE: This member is now obsolete. Instead, please use Cells.ImportData(IDataReader, int, int,ImportTableOptions) method. This property will be removed 12 months later since December 2018. Aspose apologizes for any inconvenience you may have experienced.

See Also