The
DbDataTable class represents a single object that provides all of the functionality needed to retrieve and manipulate data from a data source. The
DbDataTable class is built using existing ADO.NET components.
This sample shows how to use
DbDataTable. The routine accepts DbTable-compatible object and IDbConnection implementor object as parameters. After SQL query text has been set, the data is retrieved from the table.
static void UseDataTable(DbDataTable myDataTable, IDbConnection myConnection)
{
myDataTable.Connection = myConnection;
myDataTable.SelectCommand = myConnection.CreateCommand();
myDataTable.SelectCommand.CommandText = "SELECT * FROM Test.Dept";
try
{
myDataTable.Fill();
myDataTable.Rows[1].Delete();
myDataTable.Update();
foreach(DataRow myRow in myDataTable.Rows)
{
foreach(DataColumn myCol in myDataTable.Columns)
{
Console.Write(myRow[myCol] + "\t");
}
Console.WriteLine();
}
}
finally
{
myDataTable.Clear();
}
}
Public Sub UseDataTable(ByVal myDataTable As DbDataTable, ByVal myConnection As IDbConnection)
myDataTable.Connection = myConnection
myDataTable.SelectCommand = myConnection.CreateCommand()
myDataTable.SelectCommand.CommandText = "SELECT * FROM Test.Dept"
Try
myDataTable.Fill()
myDataTable.Rows(1).Delete()
myDataTable.Update()
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.Clear()
End Try
End Sub