FreakOut.classes.DatabaseConnector.PlatformID C# (CSharp) Method

        public int PlatformID(string NameOfPlatform)
        {
            int PlatformID = 0;
            if (!connectionopen)
            {
                DBConnector.Open();
                connectionopen = true;
            }

            FbTransaction DBTransaction = DBConnector.BeginTransaction();
            FbCommand DBCommand = new FbCommand("SELECT FROM platforms WHERE name_of_platform='" + NameOfPlatform + "'", DBConnector, DBTransaction);
            FbDataReader DBReader = DBCommand.ExecuteReader();
            int x = 0;
            while (DBReader.Read())
            {
                if (x == 0)
                    PlatformID = DBReader.GetInt32(1);
                else
                    PlatformID = 0;
            }

            DBConnector.Close();
            connectionopen = false;

            return PlatformID;
        }