Question

我目前正在开发一个C# MySQL Export Utility。由于这一原因,我不了解表格中每个领域的领域或数据类型。

当我从数据库的表格中输出数据时,它显示的是MySQL的变幻影,称它无法更改MySQL的截止日期/时间。日期: 在我制定法典时,它正在这样做:

if (!reader.isDBNull(fieldCount)){}

However, when the exception was thrown on this line I fixed it by adding Allow Zero DateTime=true to the MySQL Connection string but not it is displaying the error when I run the code

string value = reader.getString(field);

How can I get around this issue bearing in mind I am not going to know what data type is or what the value is going to be.

Thanks for any help you can provide.

Answer 1

You can get the raw value as object:

object value = reader[field];

Then decide what to do based on its type:

if (value is string)
{
    string sVal = value.ToString();
    //handle as string...
}
else if (value is DateTime)
{
    DateTime dtVal = (DateTime)value;
    //handle as DateTime...
}
else
{
    //some other type
}

也许不会说谎,而是应该工作。

Answer 2

如果你与MySQLLinkor/Net读到DATETIME值,并设定“零日期”,那么你就应当使用读者。 GetValue()方法;在这种情况下,读者将返回一个MySqlDatetime物体,价值000-00-00:00:00。

rel=“nofollow”> 联接网/网络联系参考

Note, than .NET DateTime.MinValue = 00:00:00.0000000, January 1, 0001.

http://www.devart.com/dotlink/mysql/“rel=“nofollow”>dotConnect for MySQL.

Answer 3

我在一个老的开放源项目中处理了类似这个问题。见here,载于我的Util.DefaultConvert()方法。

骗局将使用<代码>Type.GetTypeCode()并转而使用结果。

然后对每种类型实行严格的换算。在那里,你可以核查你需要做什么。我在那里也有我的Sql供应商。

友情链接