110,535
社区成员
发帖
与我相关
我的任务
分享
System.Threading.ThreadAbortException: 正在中止线程。
在 System.Net.UnsafeNclNativeMethods.OSSOCK.recv(IntPtr socketHandle, Byte* pinnedBuffer, Int32 len, SocketFlags socketFlags)
在 System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags, SocketError& errorCode)
在 System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
在 System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
在 System.IO.BufferedStream.ReadByte()
在 MySql.Data.MySqlClient.MySqlStream.LoadPacket()
在 MySql.Data.MySqlClient.MySqlStream.OpenPacket()
在 MySql.Data.MySqlClient.NativeDriver.ReadOk(Boolean read)
在 MySql.Data.MySqlClient.NativeDriver.SetDatabase(String dbName)
在 MySql.Data.MySqlClient.MySqlConnection.ChangeDatabase(String databaseName)
在 MySql.Data.MySqlClient.MySqlConnection.Open()
/// <summary>
/// 向MySql数据库更新数据
/// </summary>
/// <param name="parkType">映射表的对象</param>
/// <returns></returns>
public int Update(string sql)
{
// 插入数据到MySql数据库
Console.WriteLine("向MySql中更新一条数据 ...");
MySqlCommand cmd = new MySqlCommand(sql, this.mySqlConn);//声明执行sql文本或存储过程的对象
int row = cmd.ExecuteNonQuery();
this.Close();
return row;// 执行后返回影响的结果行数
}
Hi Adil,
This seems similar to issue: http://bugs.mysql.com/bug.php?id=57365
The workaround then was to customize the net_xxx_timeout settings.
For example, issue the following after openning your connection and
before executing the datareader:
MySqlCommand cmd = new MySqlCommand(
"set net_write_timeout=99999; set net_read_timeout=99999", con );
cmd.ExecuteNonQuery();
Let us know if that solves the prb.