DataTable Object

Represents one table of in-memory data retrieved from a database using an OleDbConnection or OdbcConnection instance.

Table of Contents [Hide/Show] Instance Properties    RowCount Instance Methods    GetFieldString ( Number, String )    GetFieldString ( Number, String, String )    GetFieldNumber ( Number, String )    GetFieldNumber ( Number, String, Number ) See Also

Instance Properties

RowCount

Gets the number of rows in the DataTable.

Accessibility : Read Only

Type: Number

Instance Methods

GetFieldString ( Number, String )

Retrieves a value from the DataTable at the specified row and column as a String.

Syntax:


Parameters:



Return Value


Example:

dt = db.GetDataTable("select * from mytable");
s = dt.GetFieldString(0, "col1");

GetFieldString ( Number, String, String )

Retrieves a value from the DataTable at the specified row and column as a String. If the value is null, then the specified default value is returned.

Syntax:


Parameters:




Return Value


Example:

dt = db.GetDataTable("select * from mytable");
s = dt.GetFieldString(0, "col1", "myvalue");

GetFieldNumber ( Number, String )

Retrieves a value from the DataTable at the specified row and column as a Number.

Syntax:


Parameters:



Return Value


Example:

dt = db.GetDataTable("select * from mytable");
n = dt.GetFieldNumber(0, "col2");

GetFieldNumber ( Number, String, Number )

Retrieves a value from the DataTable at the specified row and column as a Number. If the value is null, then the specified default value is returned.

Syntax:


Parameters:




Return Value


Example:

dt = db.GetDataTable("select * from mytable");
s = dt.GetFieldNumber(0, "col2", 0);

See Also