Disconnects
DbDataTable from the data source and frees server resources allocated for the query.
The following example demonstrates how to use the
Close() method.
static void UseDataTable(DbDataTable myDataTable, DbCommand myCommand)
{
myCommand.CommandText = "SELECT * FROM Test.Dept";
myDataTable.SelectCommand = myCommand;
try
{
myDataTable.Open();
foreach(DataRow myRow in myDataTable.Rows)
{
foreach(DataColumn myCol in myDataTable.Columns)
{
Console.Write(myRow[myCol]+"\t");
}
Console.WriteLine();
}
}
finally
{
myDataTable.Close();
}
}
Public Sub UseDataTable(ByVal myDataTable As DbDataTable, ByVal myCommand As DbCommand)
myCommand.CommandText = "SELECT * FROM Test.Dept"
myDataTable.SelectCommand = myCommand
Try
myDataTable.Open()
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.Close()
End Try
End Sub