public void UseDataAdapter(DB2Connection db2Connection)
{
DB2DataAdapter myAdapter = new DB2DataAdapter("SELECT DeptNo, DName FROM Dept", db2Connection);
myAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;
DataSet myDataSet = new DataSet();
myAdapter.Fill(myDataSet,"Departments");
object[] rowVals = new object[2];
rowVals[0] = 40;
rowVals[1] = "Operations";
myDataSet.Tables["Departments"].Rows.Add(rowVals);
myAdapter.InsertCommand = new DB2Command("INSERT INTO Dept (DeptNo, DName) " +
"VALUES (:DeptNo, :DName)", db2Connection);
myAdapter.InsertCommand.Parameters.Add("DeptNo", DB2Type.Int, 0, "DeptNo");
myAdapter.InsertCommand.Parameters.Add("DName", DB2Type.VarChar, 15, "DName");
myAdapter.Update(myDataSet,"Departments");
//Get all data from all tables within the dataset
foreach(DataTable myTable in myDataSet.Tables)
{
foreach(DataRow myRow in myTable.Rows)
{
foreach (DataColumn myColumn in myTable.Columns)
{
Console.Write(myRow[myColumn]+"\t");
}
Console.WriteLine();
}
Console.WriteLine();
}
}