DB2DataTable Constructor(DB2Command,DB2Connection)
Initializes a new instance of the
DB2DataTable class.
This sample shows how to create a
DB2DataTable and retrieve data from a table.
public void UseDataTable(DB2Connection db2Connection)
{
DB2Command db2Command = new DB2Command("SELECT * FROM Dept");
DB2DataTable myDataTable = new DB2DataTable(db2Command,db2Connection);
try
{
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 db2Connection As DB2Connection)
Dim db2Command As DB2Command = New DB2Command("SELECT * FROM Dept")
Dim myDataTable As DB2DataTable = New DB2DataTable(db2Command, db2Connection)
Try
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