C# mysql MySqlDataAdapter fill(dataset) 字符串格式错误

发布时间 2023-06-27 08:52:06作者: madvivi

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;
}