static void UseDataTable(DbDataTable myDataTable, DbConnection myConnection) {
myDataTable.Connection = myConnection;
myDataTable.SelectCommand = myConnection.CreateCommand();
myDataTable.SelectCommand.CommandText = "SELECT DEPTNO FROM Dept";
System.Data.DataColumn column_DEPTNO = new System.Data.DataColumn();
System.Data.DataColumn column_DNAME = new System.Data.DataColumn();
System.Data.DataColumn column_LOC = new System.Data.DataColumn();
column_DEPTNO.ColumnName = "DEPTNO";
column_DEPTNO.DataType = typeof(int);
column_LOC.ColumnName = "LOC";
column_DEPTNO.DataType = typeof(string);
myDataTable.Columns.AddRange(new System.Data.DataColumn[] {column_DEPTNO, column_DNAME, column_LOC});
myDataTable.FetchAll = true;
myDataTable.Open();
Console.Write("DEPTNO column is loaded");
myDataTable.ReadComplete(myDataTable.Rows[0]);
Console.Write("DEPTNO and LOC columns are loaded");
}