MySQL Timeout expired processing

First, the problem found

Second, analysis of the problem

. NET long-time connection to MySQL causes timeouts;

Mode one: When the connection is exhausted, close the connection

Mode two: Increase the execution SqlCommand time of C #

Third, solve the problem

Added this sentence, the problem solved

using(Mysqlconnection conn =Newmysqlconnection (mysqlcon.connectionstring)) {mysqlDa.SelectCommand.Connection=Conn; //0 Permanent on the table, default isMysqlDa.SelectCommand.CommandTimeout =0; Conn.    Open (); Mysqltransaction Tran=Conn.    BeginTransaction (); MysqlDa.SelectCommand.Transaction=Tran; Mysqlda.fill (DS,"Sp_allinsert");    Tran.commit (); stringReturnstr =Return_str.    Value.tostring (); Tbcompanyid.text=Returnstr; MessageBox.Show (RETURNSTR);}

MySQL Timeout expired processing