MySql.Data.MySqlClient.MySqlCommand.Dispose C# (CSharp) Method

Dispose() protected method

protected Dispose ( bool disposing ) : void
disposing bool
return void
        protected override void Dispose(bool disposing)
        {
            if (disposing)
            {
                if (statement != null && statement.IsPrepared)
                    statement.CloseStatement();
            }
            base.Dispose(disposing);
        }

Usage Example

Exemplo n.º 1
0
        public bool trylogin(string username, string passwort)
        {
            MySqlConnection con = new MySqlConnection("host=5.135.97.241;user=lesen;password=test234;database=test;");
            MySqlCommand cmd = new MySqlCommand("select * FROM login WHERE user = '******' AND pass = '******' AND datum >= CURRENT_DATE() - INTERVAL 0 DAY ;");
            cmd.Connection = con;
            con.Open();

            MySqlDataReader reader = cmd.ExecuteReader();
            if (reader.Read() != false)
            {

                if (reader.IsDBNull(0) == true)
                {
                    cmd.Connection.Close();
                    reader.Dispose();
                    cmd.Dispose();
                    return false;

                }
                else
                {
                    cmd.Connection.Close();
                    reader.Dispose();
                    cmd.Dispose();
                    return true;

                }
            }
            else
            {
                return false;
            }
        }
All Usage Examples Of MySql.Data.MySqlClient.MySqlCommand::Dispose