MySqlDataAdapter fill(dataset)时候报错字符串格式错误。
排查两天发现是mysql 数据表内字段设计错误,datetime 格式的字段长度设置错误,应设置为0,原先设置为6.
代码如下
try
{
using (MySqlConnection connection = new MySqlConnection(connectionString))
{
connection.Open();
MySqlCommand command = new MySqlCommand(commandText);
command.CommandType = commandType;
command.Connection = connection;
this.ValidateParameters(ref commandParameters);
if (commandParameters != null && commandParameters.Length > 0)
command.Parameters.AddRange(commandParameters);
DataSet ds = new DataSet();
MySqlDataAdapter da = new MySqlDataAdapter(command);
da.Fill(ds);
if (commandParameters != null && commandParameters.Length > 0)
command.Parameters.Clear();
return ds;
}
}
catch (Exception e)
{
throw e;
}