CReating A DataTable structure with MySql DateTime

[ediguy]

Hi all,

I'm having no luck finding info so I thought someone here might know.

I am setting up a routine whereby I have to copy the results of a MySQL stored procedure into a DataTable so that I can add fields to the end of the result.

Normally I would convert the Msql DateTime to something that I could more easily manipulate; however, the existing code that I have specifically addresses the MySql DateTime type in too many ways to easily change.

So I thought I could do something like this:

            myDataColumn = new DataColumn("ETD_DT");
            myDataColumn.DataType = System.Type.GetType("System.DateTime");
            returnDataTable.Columns.Add(myDataColumn);

And substitute "MySqlData.Types.MySqlDateTime" for "SystemDateTime", but it fails with "Column Requires a Valid DataType".

Any ideas?