Represents a single object that provides all of the functionality needed to retrieve and manipulate data from a DB2 data source.
This sample shows easiness of use of
DB2DataTable. The sample creates a
DB2DataTable object, passing it SQL query text and connection string, retrieves data from a table and modifies it. Content of the table is printed to console then. Notice that no other component needs to be created by programmer.
public void UseDataTable()
{
DB2DataTable myDataTable = new DB2DataTable("SELECT * FROM Dept",
"user id=db2admin;server=db2;database=SAMPLE;");
try
{
myDataTable.FetchAll = true;
myDataTable.Active = true;
myDataTable.Rows[3]["DName"] = "Researches";
Console.WriteLine(myDataTable.Update()+" rows updated.");
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()
Dim myDataTable As DB2DataTable = New DB2DataTable("SELECT * FROM Dept", _
"user id=db2admin;server=db2;database=SAMPLE;")
Try
myDataTable.FetchAll = True
myDataTable.Active = True
myDataTable.Rows(3)("DName") = "Researches"
Console.WriteLine(myDataTable.Update() & " rows updated.")
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