public void CreateDataAdapter(UniConnection myConnection)
{
UniCommand myCommand = new UniCommand("SELECT DeptNo, DName FROM Test.Dept", myConnection);
UniDataAdapter myAdapter = new UniDataAdapter(myCommand);
myAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;
DataSet myDataSet = new DataSet();
myAdapter.Fill(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();
}
}