Reads the schema to the data table.
[Visual Basic]
Public Function FillSchema( _
ByVal dataTable As DataTable, _
ByVal sql As String, _
ByVal connectionControl As Boolean _
) As Boolean
[C#]
public bool FillSchema(
DataTable dataTable,
string sql,
bool connectionControl
);
Parameters
-
dataTable
- DataTable.
-
sql
- SQL.
-
connectionControl
- Value that indicates whether it controls the connection automatically.
Return Value
Returns true if successful; otherwise false.
Remarks
If connectionControl is true, first of all the connection to the database is opened and at last it is closed. Even if it executes this method, the data is not read.
Example
How to read schema of the database to the data table dt.
dbData.FillSchema(dt, "SELECT * FROM xxxtbl", True)
dbData.FillSchema(dt, "SELECT * FROM xxxtbl", true);
See Also
AwDbData Class | Asterworld.Data Namespace
