MySqlConnection conn = new MySqlConnection();
            conn.ConnectionString = "DataSource=xx;Database=xx;UserID=xx;Password=xx;PORT=xx;allow user variables = true; respect binary flags=false";
            conn.Open();
            MySqlCommand cmdQry = new MySqlCommand("SELECT SP.PartNo, SPC.Description, C.Name AS CompanyName, SP.PKID AS PartNoId, C.PKID AS CompanyId " +
                "FROM aeropartslocator.StockParts SP " +
                "INNER JOIN aeropartslocator.StockPartsCompany SPC ON SP.PKID=SPC.PartId " +
                "INNER JOIN aeropartslocator.Companies C ON SPC.CompanyId=C.PKID " +
                "WHERE (SP.PartNo LIKE '%an3%' OR SP.PartNoStripped LIKE '%an3%' OR SPC.Description LIKE '%an3%') AND (SPC.Spareable=1 OR CompanyId IN (2)) " +
                "ORDER BY SP.PartNo LIMIT 0,10", conn);

            //MySqlCommand cmdQry = new MySqlCommand("SELECT SP.PartNo, SPC.Description, C.Name AS CompanyName, SP.PKID AS PartNoId, C.PKID AS CompanyId " +
            //    "FROM aeropartslocator.StockParts SP " +
            //    "INNER JOIN aeropartslocator.StockPartsCompany SPC ON SP.PKID=SPC.PartId " +
            //    "INNER JOIN aeropartslocator.Companies C ON SPC.CompanyId=C.PKID " +
            //    "WHERE (SP.PartNo LIKE '%an3%' OR SP.PartNoStripped LIKE '%an3%' OR SPC.Description LIKE '%an3%') AND CompanyId IN (2) " +
            //    "ORDER BY SP.PartNo LIMIT 0,10", conn);

            cmdQry.CommandTimeout = 0;

            MySqlDataReader dr = cmdQry.ExecuteReader();
            DataTable SchemaTable = dr.GetSchemaTable();
            DisplayData(SchemaTable);
            
            SchemaTable.Clear();
            SchemaTable.Dispose();
            dr.Close();
            dr.Dispose();

            cmdQry.Dispose();
            conn.Close();

            Console.WriteLine("Done.");

        private static void DisplayData(System.Data.DataTable table)
        {
            foreach (System.Data.DataRow row in table.Rows)
            {
                foreach (System.Data.DataColumn col in table.Columns)
                {
                    Console.WriteLine("{0} = {1}", col.ColumnName, row[col]);
                }
                Console.WriteLine("============================");
            }
        }