DataTable Column Mapping for XML

This article will demonstrate how to determine or set a SYSTEM.DATA.DATATABLE.Column as different XML nodes.

// The user must include into their class:

using System.Data;

// ==========

// To determine if a column is an XML attribute after

// loading data

// --- after loading data into the dataset

// --- and finding the table needed

mytable.Columns[].ColumnMapping == MappingType.;

----> There are 4 types

Attribute

Element

Hidden

SimpleType

Columns.MappingType Gets or Sets the mapping type for the column.

MySQL Workbench Foreign Key Restraint

In MySQL Workbench, the user can alter tables. When altering tables, the user can add 'foreign keys' and 'indexes' to tables.

MySQL Workbench will not allow the user to add foreign keys in certain situations, and will not give adequate error messages so the user can fix them.

Some important things to remember when altering a table to add foreign keys in MySQL Workbench.

1.

Both columns must be EXACTLY the same type. If one column is unsigned INT(10), the other must be unsigned INT(10).

2.

Since, MySQL Workbench will make an index of a foreign key, the foreign key MUST BE AN INDEX of the referenced table, otherwise the script will not be successful.