Active Property (DbDataTable)
Gets or sets whether a
DbDataTable is filled with data from a data source.
public bool Active {get; set;}
'Declaration
Public Property Active As Boolean
Property Value
true if a
DbDataTable is populated with data from a data source; otherwise,
false. The default value is
false.
This sample shows how to use
DbDataTable. The routine accepts DbTable-compatible object and IDbCommand implementor object as parameters. After SQL query text has been set the data is retrieved from the table.
static void UseDataTable(DbDataTable myDataTable, DbCommand myCommand)
{
myCommand.CommandText = "SELECT * FROM Test.Dept";
myDataTable.SelectCommand = myCommand;
try
{
myDataTable.FetchAll = true;
myDataTable.Active = true;
foreach(DataRow myRow in myDataTable.Rows)
{
foreach(DataColumn myCol in myDataTable.Columns)
{
Console.Write(myRow[myCol]+"\t");
}
Console.WriteLine();
}
}
finally
{
myDataTable.Active = false;
}
}
Public Sub UseDataTable(ByVal myDataTable As DbDataTable, ByVal myCommand As DbCommand)
myCommand.CommandText = "SELECT * FROM Test.Dept"
myDataTable.SelectCommand = myCommand
Try
myDataTable.FetchAll = True
myDataTable.Active = True
Dim myRow As DataRow
Dim myCol As DataColumn
For Each myRow In myDataTable.Rows
For Each myCol In myDataTable.Columns
Console.Write(myRow(myCol) & Chr(9))
Next myCol
Console.WriteLine()
Next myRow
Finally
myDataTable.Active = False
End Try
End Sub