MySql.Data.MySqlClient.MySqlConnection.CancelQuery C# (CSharp) Method

CancelQuery() public method

public CancelQuery ( int timeout ) : void
timeout int
return void
        public void CancelQuery(int timeout)
        {
            MySqlConnectionStringBuilder cb = new MySqlConnectionStringBuilder(
                Settings.ConnectionString);
            cb.Pooling = false;
            cb.ConnectionTimeout = (uint) timeout;
          
            using(MySqlConnection c = new MySqlConnection(cb.ConnectionString))
            {
                c.isKillQueryConnection = true;
                c.Open();
                string commandText = "KILL QUERY " + ServerThread;
                MySqlCommand cmd = new MySqlCommand(commandText, c);
                cmd.CommandTimeout = timeout;
                cmd.ExecuteNonQuery();
            }
        }

Usage Example

Exemplo n.º 1
0
 /// <summary>
 /// Attempts to cancel the execution of a currently active command
 /// </summary>
 /// <remarks>
 /// Cancelling a currently active query only works with MySQL versions 5.0.0 and higher.
 /// </remarks>
 public override void Cancel()
 {
     if (connection != null)
     {
         connection.CancelQuery(connection.ConnectionTimeout);
     }
     Canceled = true;
 }
All Usage Examples Of MySql.Data.MySqlClient.MySqlConnection::CancelQuery